Hi Kevin,

I think the following may be want you want:

SELECT DISTINCT EntryDate, BatchId;
   FROM Resh;
   ORDER BY EntryDate ;
   INTO CURSOR Temp1

or

SELECT EntryDate, BatchId;
   FROM Resh;
   GROUP BY EntryDate, BatchId ;
   ORDER BY EntryDate, BatchId ;
   INTO CURSOR Temp1

Hope this helps,
Gavin...

>How do I select out all records with a distinct combination of 2 fields?
>
>SELECT EntryDate, BatchId;
>  FROM Resh;
>  ORDER BY EntryDate;
>  INTO CURSOR Temp1
>
>
>This gives me ALL records. I just want the records where the combination
>of the 2 fields are unique.
>
>Thanks