This is an easy one!!

[ACE]

I'm drawing a blank here, all I want to do is a simple query on a table. I have a column of codes such as VGH, TRJ, ISK, etc. There are anywhere from 10 to 100 of each code. I want to find out how many different codes there are. I'm sure this is very simple to do!!!

 

[MarkP]

You can open the query in design view and right click and select properties. Then select unique values = yes

 

[Mile-O]

Use the Find Duplicates Query Wizard then change the SQL created to >=1 from >1

 

[dcx693]

Or create a totals query, grouping on the code field.

 

[ACE]

Thanks for all of your solutions!!!