Question regarding query parameters

[AcceSs-AbLe]

Hi,

I have 7-8 queries set up and i have a [Start Date]/[End Date] parameter setup for all those queries. However, I am trying to avoid entering the dates 7-8 times, is there a shortcut where i can just enter the dates once and it applies to all the other following queries?

Thanks

 

[dk]

Hi,

How about using a form with a textbox or something and have your query refer to that? This is the SQL produced by Access when I use this method:-

SELECT PremiumData.* FROM PremiumData WHERE (((PremiumData.Period)=[Forms]![frmCriteria]![txtTheDate]));