A perameter dependant on another

[lovemuscle2005]

Hi all,

I have 3 queries all the same but for different months, i.e. a different date perameter. I want to make query1 and query2 dependant on the date in query3, i.e. if Q3 is 1/1/05, Q2 would be 1/2/05 and Q1 would be 1/3/05.

I'm using at the moment the following hardcoded perameter:

WHERE ((([Performance Figures & Store].Date)=#1/1/2005#) AND (([Customer Excellence & Store].Date)=#1/1/2005#) AND (([Store manager List & Salary Template].Date)=#1/1/2005#) AND (([ASD Rate Template & Store Lookup].Date)=#2/1/2005#));

Any ideas?

Thanks in advance

 

[Andrew Fergus]

Hi LM2005

In query 2 design view, add query 3, under the existing date field in Q2 enter the following criteria :
=DateAdd("m", 1, [query3.Date])
- assuming the query is called 'query3' and the date field in Q3 is called 'Date'.

Repeat for Q1 but change the criteria to =DateAdd("m", 2, [query3.Date])

Rather than hard code the dates, in query 3 you could use something like this :
[Enter the date (format mm/dd/yy)]
and then use the dateadd calculation on any dates that differ (e.g. the last bit : [ASD Rate Template & Store Lookup].Date)=#2/1/2005#)

HTH, Andrew.

 

[lovemuscle2005]

Thanks very much