R
Richard
I have a table that has production information by an employee number. I then
sum[Amount] that production by month to determine if it meets a minimum
amount[Qualify]. So my resulting query looks like this:
Emp Month Year Amount Qualify
123 9 2004 1700 Yes
123 10 2004 1010 Yes
123 11 2004 400 No
123 12 2004 2000 Yes
123 1 2005 2500 Yes
123 2 2005 3000 Yes
777 9 2004 2100 Yes
777 10 2004 1990 Yes
777 11 2004 1400 Yes
777 12 2004 300 No
777 1 2005 3500 Yes
777 2 2005 2000 Yes
I then need a query that will show me those employees that have previous
consecutive months that meet the minimum amounts based on the month I run the
query. So the results would look like this, if I run it in February 2005:
123 12 2004 2000 Yes
123 1 2005 2500 Yes
123 2 2005 3000 Yes
777 1 2005 3500 Yes
777 2 2005 2000 Yes
I have tried using DLookup without any success, does anyone have a suggestion?
sum[Amount] that production by month to determine if it meets a minimum
amount[Qualify]. So my resulting query looks like this:
Emp Month Year Amount Qualify
123 9 2004 1700 Yes
123 10 2004 1010 Yes
123 11 2004 400 No
123 12 2004 2000 Yes
123 1 2005 2500 Yes
123 2 2005 3000 Yes
777 9 2004 2100 Yes
777 10 2004 1990 Yes
777 11 2004 1400 Yes
777 12 2004 300 No
777 1 2005 3500 Yes
777 2 2005 2000 Yes
I then need a query that will show me those employees that have previous
consecutive months that meet the minimum amounts based on the month I run the
query. So the results would look like this, if I run it in February 2005:
123 12 2004 2000 Yes
123 1 2005 2500 Yes
123 2 2005 3000 Yes
777 1 2005 3500 Yes
777 2 2005 2000 Yes
I have tried using DLookup without any success, does anyone have a suggestion?