User selected date range appear on report?

[bfdeal31]

Hello,
I have several reports based on queries that ask the user to input dates for a time range. My queries have the following criteria for the date column:
Between [Enter a Beginning Date: ] And [Enter and Ending Date: ]
How would I make the report show what data range the info is for? I want my report to say at the top something like "Data for Date Range of" followed by the beginning date the user entered followed by the ending date the user entered. Is this possible?
Thanks for your help.

Steve

 

[Shane_Mc]

The start and end dates are obviously in the query. When you build the report from the query the easiest way (not necessarily the best) is to use the wizard. Add the fields to the report, in the detail section if necessary. Then in design view move them to the header so that it will appear only once at the top of the report.

 

[bfdeal31]

thanks, but...

Thanks but I believe what I am trying to do is a little different. Originally I did have a copy of the date from the detail area in the header but it's not exactly what I want.
What I have is one date field in my table, the date of an invoice. In the query design under the Invoice Date I have for Criteria: "Between [Enter a Beginning Date: ] And [Enter an Ending Date: ]" When the report is run two message boxes appear into which the user types the beginning date for the range in the first and the ending date for range in the second. I want whatever the user typed into those boxes to appear at the top of the report. My logic for this is that if a user enters in that they want the report to show all invoices that have dates between Jan 2002 and August 2002; if there are no Jan invoices, but perhaps the closest one to Jan is March, if I use the text boxes in the way you were suggesting, the range appearing at the top would make it appear that the report is for March to August instead of Jan to Aug. Does this make sense? Maybe I have my query set up differently then you would. Are you using additional columns of the query for the entry of start and end dates? If so, how would I use them and relate them to my Invoice Date column. I can explain further if needed. Thanks.

Steve

 

[Sohaila Taravati]

Make a text box on you report and put this for source:
="From: " &[BeginningDate] & " To " & [EndingDate]
But the critaria in your query has to exactly match. In your query you should have:
Between[BeginningDate] And[EndingDate]
I hope this helps

 

[bfdeal31]

thanks.

That worked great and was what I was trying to do. Thanks for your help.

-Steve