Report Input

[tlnini]

Sorry for another basic question. I am running a report based on a query which uses a date to filter the result. I am wondering if I can use macro to input the filter variable instead of changing it from the query side.

 

[scriverb]

You can create a parameter prompt in your query by using square brackets around your literal prompt:

WHERE (((tblYourTable.DateField)>=[Enter Date in mm/dd/yyy Format: ]));

Bob Scriver
Want the best answers? See FAQ181-2886
Nobody believes the official spokesman... but everybody trusts an unidentified source.
Author, Bagdad Bob???

 

[tlnini]

Thank!