>I need some help to figure out how I can find out which records are being "dropped" when I do a SELECT * DISTINCT. I did a search for this and came up with some suggestions but they don't seem to fit this situation. One of the suggestions was: > > >SELECT COUNT(field1) AS NumberofDup, field2 FROM MyTable GROUP BY field1 INTO CURSOR tmp > >That'd be great, but I'm doing a > >SELECT * DISTINCT, not a distinct on only one field. > > I don't exactly understand what you mean by "dropped". Also, do you mean GROUP BY field2 in the above?