multiple parameters from queries in a macro

[christak]

I have several parameter queries that I have put into a macro. They are all date parameters, and I don't want to type the same date several times. Is there a way to just enter one date to satisfy all of the parameters?
Thanks!

 

[lespaul]

create a form to capture the date, assign the date to a variable and then insert it into all the SQL statements. Without seeing the code you're using, it's hard to tell exactly what to do!



Leslie
landrews@metrocourt.state.nm.us

There are 10 types of people in the world -
those who understand binary
and
those who don't!