access query design

[olive]

I'm creating a query that includes the cities in descending order. Each city
should appear only once. I can't get the cities to appear only once they
appear multiple times... what do I need to put for criteira?

 

[John W. Vinson]

I'm creating a query that includes the cities in descending order. Each city
should appear only once. I can't get the cities to appear only once they
appear multiple times... what do I need to put for criteira?

Open the query in design view; view its Properties; and set the Unique Values
property to Yes. If that doesn't work, please post the SQL view of the query
and perhaps some sample data.