Take data from table, make a list of unique values

K

KK

I have a table which has rows and rows that look like this:

A, 1
A, 2
A, 3
A, 3
A, 3
B, 1
B, 2
B, 2
B, 2
B, 3

I want to create a query that gives me something like this:

A, 1
A, 2
A, 3
B, 1
B, 2
B, 3

Basically create a table of unique values for each letter instead on
repeating ones.

How do I do this? Thanks.
 
P

pietlinden

I have a table which has rows and rows that look like this:

A, 1
A, 2
A, 3
A, 3
A, 3
B, 1
B, 2
B, 2
B, 2
B, 3

I want to create a query that gives me something like this:

A, 1
A, 2
A, 3
B, 1
B, 2
B, 3

Basically create a table of unique values for each letter instead on
repeating ones.

How do I do this? Thanks.
Click to expand...

SELECT DISTINCT field1, field2
FROM MyTable
ORDER BY field1, field2;
 
K

KK

One thing I just found out is that if I click on "Total" (while
creating query), the "group by" does this.

but thanks.
 
Top