Re: GROUP BY help please

[K Kleinman Zajac]

>> I ran the same thing without concatenating the names and it worked, so I
assume that is the problem, however, can it be done in one pass this way?
I'm only concatenating to save vars in the reports. <<

I do something similar, except the concatenation is done within the
original table.  I created a computed comlum that has lname + fname in the
source table.  I never have any problems grouping or sorting on it.