Including Date Range in Report Header 1

[ccooper2]

I have a query which specifies a date range and the correct data is pulled to a report with the dates for each line item. Is there a way I can get the date range that was specified to appear in the heading of the report? Thanks.

 

[GingerR]

say for example in your query your criteria are:

[Enter Start Date:] and [Enter End Date:]

then in the header of your report, copy them exactly into a text box:

="Date Range: " & [Enter Start Date:] & " - " & [Enter End Date:]

this will come out, i.e.

Date Range: 01/01/2002 - 03/31/2002

you can add formatting, i.e.

...& format([Enter Start Date:],"m/d/yy&quot & ..... to each date to make it look more normal, i.e.

Date Range: 1/1/02 - 3/31/02

hope this helps--g

 

[ccooper2]

That worked perfectly. Thanks for all of your help!