>>I see, that was just a typo, of course. BTW, why does he divide by 1000? Other than that I still don't see a difference.
>
>I think other than that they are the same. One of you groups by 1 the other by 2. I'm not sure if there's a difference. The GROUP BY clause still confuses me.
>
>The division by 1000 is mine not Cetin's. All the numbers in the report are presented in (000's). The expenses however are to the penny in the table so they need to be truncated. Maybe not the best way but it seems to work.
Ah, I see. I group by 2 and he groups by 1 because I put the Group field in the second place and he in the first.
These 2 queries were identical except for my typo. But Cetin used a good point of casting the group field to an integer. I'm not sure if this was necessary, but didn't hurt, of course.
If it's not broken, fix it until it is.
My Blog