Access 97 Date Range Report

[trussman]

Yea I know, what am I still doing using Access 97? Unfortunately it is required for a sub program to our main program. Any way, I am trying to design a simple report with a date range value requirement. In my Forms I have a date field. I would like to have it ask from what date to what date, and then give the information for those dates. It has been a long time since I have done anything in Access. I know it is a simply solution.

Thank you for you help.

 

[KenReay]

Hi

You put two text box controls on your form,

In the query on which the report is based, add a criteria

WHERE MySelectionDate BETWEEN Forms!MyForm!MyFromDate AND Forms!MyFormMyToDate

replacing all "My" words above with teh appropriate names

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK