I have access to the data repository tables which are not live, but are
updated daily.
I want to define items in the fields of these tables.
How can I run a query to find all the let's say "location names" w/o pulling
duplicates?
Thank you
You can do so, but this has nothing whatsoever to do with sorting the
table. Sort means to take a set of records and put them in a
particular sequential order; that is a different operation from
finding a subset of the records.
Given that I have no idea how your table is structured, all I can say
is that you can create a Query selecting one (or more) fields; you can
use the query's Properties box to set the "Unique Values" property to
True.
Or, you can do a Totals query; for example, if the table has a field
named Location, you can select that field *TWICE* in the query grid.
Don't select any other fields. Click the Greek Sigma icon (looks like
a sideways M) and leave one instance of Location the default Group By,
and change the other to Count. This will give you a result like
Aspen 14
Athens 8
Bali 10
Cancun 24
John W. Vinson[MVP]
