By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
432,118 Members | 1,133 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 432,118 IT Pros & Developers. It's quick & easy.

select unique identifiers

P: n/a
If I want to return only unique values from an attribute in a table,
how would I do so? The attribute may repeat across rows.

Aug 16 '06 #1
Share this Question
Share on Google+
2 Replies


P: n/a
1. Create a query using this table.

2. Drag the field you want into the design grid.

3. Open the Properties box (View menu.)

4. Set the Unique Values property to Yes.
(If you don't see this, you are looking at the properties of a field instead
of the properties of the table.)

The SQL statement (SQL View on View menu) will be something like this:
SELECT DISTINCT Field1 FROM Table1;

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"sammy" <va******@cs.stanford.eduwrote in message
news:11*********************@b28g2000cwb.googlegro ups.com...
If I want to return only unique values from an attribute in a table,
how would I do so? The attribute may repeat across rows.

Aug 16 '06 #2

P: n/a
Thanks!

Allen Browne wrote:
1. Create a query using this table.

2. Drag the field you want into the design grid.

3. Open the Properties box (View menu.)

4. Set the Unique Values property to Yes.
(If you don't see this, you are looking at the properties of a field instead
of the properties of the table.)

The SQL statement (SQL View on View menu) will be something like this:
SELECT DISTINCT Field1 FROM Table1;

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"sammy" <va******@cs.stanford.eduwrote in message
news:11*********************@b28g2000cwb.googlegro ups.com...
If I want to return only unique values from an attribute in a table,
how would I do so? The attribute may repeat across rows.
Aug 16 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.