J Jim Apr 8, 2004 #1 Is there anyway of writing code that will only display one unique value once instead of repeats? Thanks a lot
Is there anyway of writing code that will only display one unique value once instead of repeats? Thanks a lot
J Joe Fallon Apr 9, 2004 #2 Lots of ways. One is to use the DISTINCT keyword. Select Distinct FName From Employees Another is to use the Totals query button which does a Group By. Select FName From Employees Group By FName They both do the same thing.
Lots of ways. One is to use the DISTINCT keyword. Select Distinct FName From Employees Another is to use the Totals query button which does a Group By. Select FName From Employees Group By FName They both do the same thing.
