>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...]
Insanity: Doing the same thing over and over and expecting different results.