Report Data Range

[CHRIS31849]

I downloaded some access templates from the Microsoft Access site. Some of these templates have reports that when opened bring up a small pop-up window asking for a beginning and ending date and filters only the dates in between into the report. Is this possible to reproduce this into my reports? Where could I find out how to accomplish something like this?

 

[Trendsetter]

Chris - if you have the template files you have the examples in front of you - open the forms in design view and see how they are constructed and what happens with the data etc.. etc..
Happy to help!

 

[CHRIS31849]

I studied this thing in design view and I also tried copying it over to my file but I got an error message. I was thinking I might try copying my tables into the template and see what I can make hapen that way.

 

[CosmoKramer]

The easiest way to accomplish this is to add parameters to your query.

In design view of your query enter a statement like this in the criteria box for your date field:

Between [Enter Beginning date] And [Enter Ending date]

Whatever is between the square brackets will appear as the text in the pop-up windows. Those dates will be used as the criteria for your report.

You can also use these parameters in the header of your report to show the date range requested. You can add a text box with a control source similar to this:

="For the dates " & [Enter Beginning date] & " to " & [Enter Ending date]