filtering out all duplicates in a field

  • Thread starter Thread starter EEVtec
  • Start date Start date
E

EEVtec

Guest
I have a list of text values. Many of them are duplicates. For example .....

Adam
Adam
Adam
Jon
Jon
Derrick
Chris
Chris
Chris

What commands would i use to put a criteria on this query where it will only show one occurence of each name like ...

Adam
Jon
Derrick
Chris


Thanks for your help

Josh
 
Try clicking the sigma (greek E) buttun, which should group your results
 
Thanks for your help mark, i'm new at access if you couldn't tell :P
 

Users who are viewing this thread

Back
Top Bottom