Query - Show One of Everything

D

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
 
C

Chris

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

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top