REPORT RUNNING OF SQL QUERY

[timlowe]

Hi,

I have a report that is running of an sql query. What i am trying to do is have a prompt in the report that will as me for the date range and have the sql pick only the events in the date range.

Can someone help me with this?

Thanks
Tim

 

[dhookom]

You can create a form (frmDates) with two text boxes (txtStart and txtEnd). Then add a criteria to the report's recordsource query under the date field/column:
BETWEEN Forms!frmDates!txtStart and Forms!frmDates!txtEnd

You could also use a parameter query (check Help) but I hate parameter queries and never use or recommend them.


Duane
MS Access MVP
Find out how to get great answers faq219-2884.