russi
04-11-2002, 07:43 AM
Hi. Might be a little complicated so if I do not explain well ask me to re-try.
A form has a stored date of ApplicationDate. Staff has trouble determining which quarters of which years they must look at past client wages for.
For example, they need to look at the 2nd calendar quarter before the quarter of the application date. (ie, for ApplicationDate of 2/7/02, they need to check the 3rd quarter of 2001)
I want to create a query that would automatically list those whose ApplicationDate is in a specific date range (I already know how to do that)and the appropriate calendar quarter to look to for wages.
(Note: the past wages exist in a separate datbase whose 'custodians' will not allow this one to access directly. Thus the need for them to know what quarter to look up there.)
Russ
A form has a stored date of ApplicationDate. Staff has trouble determining which quarters of which years they must look at past client wages for.
For example, they need to look at the 2nd calendar quarter before the quarter of the application date. (ie, for ApplicationDate of 2/7/02, they need to check the 3rd quarter of 2001)
I want to create a query that would automatically list those whose ApplicationDate is in a specific date range (I already know how to do that)and the appropriate calendar quarter to look to for wages.
(Note: the past wages exist in a separate datbase whose 'custodians' will not allow this one to access directly. Thus the need for them to know what quarter to look up there.)
Russ