Search report

[Banderas23]

I have a database that holds information on departure dates. And on these dates I print off a designed report that I want to auto fill the rest of the information.

What I need to do is when I open my report I want it to ask for departure date which I enter then it will. Ron up only the records for that date. I print off the report and it's done. I created a report and made it look like I need it too but have no idea how to make it only bring up records for a specific date range. Once it brings up all records for a date it will auto populate the other fields like first name and surname etc..

Any ideas?? I thought it would be a query, do I have to create a query then link each individual field or is there an easier way of doing this?

Cheers

Antony

 

[pbaldy]

Most of us would use a query as the source of the report, and a form for the user to enter the 2 dates. The query would have a criteria like:

Between Forms!FormName.FromDateTextbox And Forms!FormName.ToDateTextbox

 

[Banderas23]

Need this to be a one date search criteria. But I'll take a look at that later and see if that's best way to build.

 

[pbaldy]

You said date range. This would be easier for a single date:

http://www.baldyweb.com/wherecondition.htm

 

[Banderas23]

Cheers amigo, I'll take a look and see if. Can get it working..

 

[pbaldy]

No problem, post back if you get stuck.