>Thanks Mark. I understand this now. I realized that I had to add fields to group by clauses if one already existed, just didn't realize that it was a requirement in some cases to have one.
>
>thank you all very much!
You can get more from VFP Help. Just look for SET ENGINEBEHAVIOR topic, among others.
Mark McCasland
Midlothian, TX USA