>Garrett,
>
>Thanks... but I don't understand. I'm not trying to group at all, I completely understand that when I have a group by clause and am trying to group, that I need to make sure all fields are listed there, but I'm not attempting to nor do I want to group anything here. Why would it force me to have a group by clause? I haven't been required to group any other select statement in any of my other code, why is it requiring it here?

In VFP8 it would. VFP doesn't know from which record to take values for the fields

(aTmpData.nRein0 + ;
aTmpData.nRein30 + ;
aTmpData.nrein90 + ;
aTmpData.nrein91 + ;
aTmpData.nrein181),