Recent content by AccessNData

Thank you for all your help. I got it to work using the category by in the end. Not really sure how to use VBA for queries. Have only used it for controls, but I'm slowly learning. Thanks again.

Because it seems like such a simple thing to do, but when I do it, all the categories come up multiple times. I couldn't get that to show just one of each category so I can tell how many unique categories there are.

I am just starting out in access. This seems like a really dumb question, but I have a table that has different vehicle models. There is a "category" field that has vehicles under boats, cars, planes, heli, etc... How do I make a query that will only show the different categories that are used...