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