Adding query date range to report 1

[KerryL]

If this has been asked and answered already, I apologize, but I didn't see anything similar in the subject lines.

My report is based on a query. Within the query is a Completion Date field for which I've entered the following criteria: "Between [Enter Begin Date] And [Enter End Date]"

This creates a report based on the range of Completion Dates entered by the user.

My question is, what is the best way to get the user's date range input onto the report itself? For instance, if the user enters 5/01/01 and 5/31/01 as the begin and end dates, I'd like that range to be placed in a text box on the report header so someone reading the report knows it is for projects completed between May1 - May 31.

I'm not sure how to transfer the user's entries into usable/printable data. Do I have to do it with code or can I edit the text box to capture the user's input?

Any help will be appreciated. Thanks.

Kerry

 

[JoeMiller]

Put controls on the report that reference your criteria input.

ControlName: txtBeginDate
ControlSource: =[Enter Begin Date]

Painless eh?!

HTH Joe Miller
joe.miller@flotech.net