access query design

  • Thread starter Thread starter olive
  • Start date Start date
O

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?
 
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?
Click to expand...

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.
 
Back
Top