Query-Parameter Help

[coolkake]

All

I'm trying to figure out a way to have the parameter be input once but use that value on two separate fields in my query. I've got two separate tables and both have fields that dates. My parameters are Start Date and End Date and I want the query to show me all the records in both tables that meet the parameters.

Right now I have to enter in my parameters twice, it's moved from pet peeve to must be fixed on my list of things to do so any help will be greatly appreciated :->

Thanks

Kake

 

[Junior1544]

here's one of the way's i do this...

make a small form, on the form have a text box for each paramater you want... then in the query, Reference the
forms![Form_Name]![Control_Name]
See if you can get that to work...

--James
junior1544@jmjpc.net
Life is change. To deny change is to deny life.