Pulling Between dates into multiple queries

Hi!

I have 22 seperate queries which run every month and they all have the following field

WHERE (((Clients.InputDate) Between #3/11/2005# And #4/1/2005#))

The format at the moment means that the dates have to be manually inserted for each query every month.

What i would like to create is a seperate table to which i can add the dates for that month and have the queries automatically pull the dates from that table - saving the time inserting them into each one manually.

I have created a date table with startdate and enddate and tried to amend the queries between bit as follows but with no luck.

Between [Date_Table]![startdate] And [Date_Table]![enddate]

Any help would be appreciated.

Cheers
Miura

This will take a little effort but... first write a new query (1) from the table holding your dates. Now go to your established queries and use this query (1) date field instead of the table date field. Once the table date field is replaced in each of your queries you can just add the line to query (1) "between date and date". That will establish your date for all you other queries without you having to retype. Hope this works for you. PS I named the query in my explanation "(1)" just to differentiate it from the all the other queries you have...