Repeating values

J

Jim

Is there anyway of writing code that will only display one
unique value once instead of repeats? Thanks a lot
 
J

Joe Fallon

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.
 
Top