Creating A Report To Be Viewed Within A Specific Timeframe

[JRA]

Hi ...

I'm try to set up my report so that it's date specific, meaning that, what I would like to happen is when the user presses either the 'Preview' or 'Print' button on my form a message box will then appear asking the user to input a start and end date. The report will then either be previewed or printed within the designated timeframe.

Can anybody help me with this?

Thanks,
James.

 

[KyleS]

The easiest way to do this would be to set the criteria in your underlying query.

Go into the design mode of your report, and open up report properties. Under Datasource click the button all the way to the right that has 3 periods in it "..." - this wiil take you to the design of your uderlying query (the query that gets the data to run the report) and under the column with the date field, enter this:
Between [Enter Start Date:] and [Enter Finish Date:]

Kyle :

 

[JRA]

That's great Kyle !!

It worked perfectly. I thought it would have been more complicated than that.

Thanks,
James.