Query - Show One of Everything

[Debra Ann]

Access 2003:

I have a table with two columns. The first column has the same information
repeated over and over to match up with the unique information in the second
column:

001 UA3
001 UQ4
002 3DZ
002 U7C

I need to run a query that will show only the first field but without the
repeats. Therefore, the query for the above info should show:

001
002

How do you create this query?

Thank you in advance.

Debra Ann

 

[Chris]

Hi,
Just create a new select query, selecting just the first column. Then,
hit the "group by" button.

 

[Debra Ann]

Thank you very much

Hi,
Just create a new select query, selecting just the first column. Then,
hit the "group by" button.

 

[Krzysztof Naworyta]

Or use "Distinct" word:

Select Distinct
FirstField
Form
MyTable

--
KN

Juzer Chris <[email protected]> napisaÅ‚
| Hi,
| Just create a new select query, selecting just the first column.
| Then,
| hit the "group by" button.
|
| "Debra Ann" wrote:
|
|| Access 2003:
||
|| I have a table with two columns. The first column has the same
|| information repeated over and over to match up with the unique
|| information in the second column:
||
|| 001 UA3
|| 001 UQ4
|| 002 3DZ
|| 002 U7C
||
|| I need to run a query that will show only the first field but without
|| the repeats. Therefore, the query for the above info should show:
||
|| 001
|| 002
||
|| How do you create this query?
||
|| Thank you in advance.
||
|| Debra Ann

--
KN

archiwum grupy:
http://groups.google.pl/advanced_search
(grupa: pl*msaccess)