Get unique values in expression builder

C

Corey

I'm new to Access and am trying to create some simple SQL queries with the
expression builder. I want to be able to select unique values from my tables
in the builder, without having to type them in manually.

There are three columns at the bottom of the expression builder. In the
first, I select a table. In the second, I select a field. And in the third
I would expect to be able to select a unique value in this field (I'm able to
do this in the expression builder i use in other db software). But all it
says is <value>. Is this really all you get or am I missing something?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top