Re: Date range on reports

Would you mind sharing some information about your macro? If you want
assistance, you need to provide enough information to allow someone to
provide help.

--
Duane Hookom
MS Access MVP
--

"Mark_Milly" <MarkMilly@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:01AC05F6-8EF0-428D-A3B9-6F3D1134CEC1@xxxxxxxxxxxxxxxx
> Sorry Al,
>
> I meant "macros", i have created a macro to ask for a date range and need
> this date range to show on my report.
>
> Sorry for any confusion
>
> Cheers Mark
>
> "Al Camp" wrote:
>
>> Mark,
>> Not sure what you mean by "popups."
>> Do you mean you created a parameter query, and two "Input Boxes" come
>> up
>> to prompt the user for a StartDate and EndDate?
>>
>> If that's so, then you probably have two parameters in the query
>> behind
>> your report.
>> Something like...
>> Between [Enter Starting Date] and [Enter Ending Date]
>> Given that example, an unbound text control on the report with a
>> Control
>> Source of...
>> = "From " & [Enter Starting Date] & " to " & [Enter Ending Date]
>> would yield the "date subtitle" your looking for in your header.
>> --
>> hth
>> Al Camp
>> Candia Computer Consulting - Candia NH
>> http://home.comcast.net/~cccsolutions
>>
>>
>> "Mark_Milly" <MarkMilly@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
>> news:90655C4C-F7C3-435D-B3C8-50490A0C389F@xxxxxxxxxxxxxxxx
>> > Hi Guys,
>> >
>> > I have created a report for monthly sales with popups to enter the date
>> > range. How can I show the date range on the header of the report?
>> >
>> > If anyone can help it would be greatly appreiciated.
>> >
>> > Cheers Mark
>>
>>
>>


.

Relevant Pages

  • Re: Date range on reports
    ... box to your report with a control source like: ... > In the Database window (Database window: The window that appears when you ... > In the New Form dialog box, click Design View, and click OK. ... > Begin by clicking Macro Names to display the Macro Name column. ...
    (microsoft.public.access.reports)
  • Re: Date range on reports
    ... Create an unbound form (unbound form or report: A form or report that isn't ... In the Database window (Database window: The window that appears when you ... In the New Form dialog box, click Design View, and click OK. ... Begin by clicking Macro Names to display the Macro Name column. ...
    (microsoft.public.access.reports)
  • Re: Cmd button to print report.
    ... I was referring to the VB code behind an Event Procedure. ... report macro, since I don't see a Refresh available as a command. ... If your button to print the report were named cmdPrintReport, ... >> Candia Computer Consulting - Candia NH ...
    (microsoft.public.access.forms)
  • Re: Date range on reports
    ... Without knowing where your report parameters were coming from, ... >>> open an Access database or an Access project. ... >>> In the New Form dialog box, click Design View, and click OK. ... >>> Begin by clicking Macro Names to display the Macro Name column. ...
    (microsoft.public.access.reports)
  • Re: D3 Output processor macros
    ... Actually I'm creating a pretty good looking report with OP. ... that I found has to do with the .TCL command. ... ..TCL command was inserting 'extraneous' form-feeds in the middle of the ... > macro that can be inserted anywhere with identical results. ...
    (comp.databases.pick)
Loading