Producing reports based on start and end dates

[Lockstock2SB]

Hi All,

I dont know if this is possible - but if it is i would really appreciate a nudge in the right direction. I have been pulling my hair out practically over how to do this :

I would like to have a form with a button, that when pressed, opens a smaller form in which you have to enter 2 dates. The start date, and the end date. After this you would then hit the submit button, and a preview of a report comes up - displaying the data from my table - but only the records between the 2 dates.

Possible or not ? Any help would be appreciated - bearing in mind i am a novice at programming !!

Thanks

Steve

 

[KerryL]

Yes indeed, it's very possible to produce a report that lists data within a user-defined date range.

The easiest way is to enter a date range criteria statement in the query. For instance, if you have a date field in the table called EnterDate, put the following statement in the criteria line of the EnterDate column within the query:

Between [Enter start date:] And [Enter end date:]

This should create a prompt for the date range. To test it, click on the ! while in the query.

Good luck!