Query Result Help

[melodyF]

Overview of problem: The query I have consist summing up employees Ind Points, Team Points, and calculating payouts and potential payouts using my month and year field for my criteria to break my data down into quarer years. Jan,Feb,March w/ year 2002 would be QTR1. I also have a field in my query named disqualifier, in which can be a number from 1-8 and can be entered monthly. If the disqualifier is not null than the employees payout will = 0.

The problem is that you input a disqualifier
on the month that that it happens, so when I run my query I can get three rows for one employee. "I only want one" How can a write a function,etc that says if disqualifier is > 0
than disqualifier = first disqualifier entered. If Disqualifier is Null than do nothing.

Man, I hope this is not to confusing..

Thanks.. You guys are the best.........

 

[David R]

Do you just want to know if there's been any disqualifiers for that quarter at all? Or does it have to be the first one?

Try this:
Click the sigma at the top to turn on Totals Query options. (The sideways M)
Quarter: Format([DateField],"q"), Group By
(You may need a similar field for Year)
Disqualified, Sum

Now anything with a value in Disqualified should be Disqualified for the quarter, regardless of how many times.