How do I build a query that that list all the states but will show each state only once?

[IamKJVonly]

I know this has to be something simple but I can't figure out how to do it.


I can build a query that list all the states in my state field in my table but I wind up wiith 50 New Yorks or 30 Floridas and etc.

I want the query to show each state only once. No duplicates.

I know it has to be something simple but my searches give me too many posts to go through or not enough post.
I hate to post this question but thanks foe any help you can give me.
Dave

[kd2017]

Read up on SELECT DISTINCT

[JoeM]

You can also do it using an Aggregate Query, grouping on the State Name.

[IamKJVonly]

Well it took me over 2 hours to figure I needed to mark the property "Unique value" to yes to get what I wanted.
Thanks for forcing me to look in

Aggregate Query and grouping on the State Name and

SELECT DISTINCT.
While trying to figure these things out I stumbled across the

"Unique value" property. page 277 in Access 2010 for dummies.

Probably if I had worded the question better you would have been able to give me the answer right off. Sorry about that.

Now my next problem How do I mark this thread solved?
Dave

[JoeM]

For an Aggregate Query, all you would need to do:
- Create a new query
- Add the table where this State field resides
- Add the State field to the query
- Click on the Totals button (looks like a Sigma)
- View your results

That's it!

As for marking the thread as solved, see here: https://www.accessforums.net/showthread.php?t=1828