|
|
|||||||||
|
|||||||||
|
|||||||||
| |
|||
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Display Modes |
|
#1
|
|||
|
|||
|
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 |
|
#2
|
|||
|
|||
|
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...
|
![]() |
| Viewing: Dev Articles Community Forums > Databases > Microsoft Access Development > Pulling Between dates into multiple queries |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|