>>Hi Trey,
>>
>>Working just fine in VFP7. Adding any of the aggregates gives me "Cannot GROUP by aggregate field." Adding the payroll logical was my first guess - no dice. Same error. Guess here that the IIF() constitutes an aggregrate field?
>>
>
>Hmm, iif()s group by just fine as far as i can tell.
>SWAG: You sure you got the column number right in the group by? [he says from too much experience...]

LOL! Me too :-) I have tried them by number(position), field names, the AS names. I'm at a loss. I'm about to toss it and start over. It's going to be a long weekend... Thanks, Trey.