Displaying no duplicate records

[aaron_brown_GC]

My recordset contains reservation information, with customer names and numbers repeated over and over.

Is there a way to display each customer's info only once (perhaps in a new table?)

Thanks,

Aaron

 

[araskas]

use DISTINCT clause.

SELECT DISTINT cName, cID
FROM myTable;

Type this in SQL window and you will not see any duplicates.