select unique identifiers

[sammy]

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.

[Allen Browne]

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.

[sammy]

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.