Unique Values Queries

[Ed Crawford]

It's been a long time since I used Access but in Access 2000 queries could
easily be made to return only unique values just by changing the property on
the query. I can't find this anywhere in Access2007. Can someone point me
in the direction.

 

[MGFoster]

It's been a long time since I used Access but in Access 2000 queries could
easily be made to return only unique values just by changing the property on
the query. I can't find this anywhere in Access2007. Can someone point me
in the direction.

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Click the tables pane of the query design view. Click the menu option:
View > Properties. Change the "Unique Values" property from No to Yes.

Also, in SQL View you can put the DISTINCT keyword in the SELECT clause:

SELECT DISTINCT column_name, column_name, ...

--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)
** Respond only to this newsgroup. I DO NOT respond to emails **

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBSe/zy4echKqOuFEgEQJGYQCeNro6Aeq0cki8LFxFmv9kmYcMzqUAnAo8
rvw6CuFayBEjE8O1o8crmmDa
=FGUP
-----END PGP SIGNATURE-----