Re: Date range on reports

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
Loading