Take data from table, make a list of unique values

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.

On Jul 15, 9:50*am, KK wrote:
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.

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

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

but thanks.

On Jul 15, 9:53*am, "
wrote:
On Jul 15, 9:50*am, KK wrote:





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.

SELECT DISTINCT field1, field2
FROM MyTable
ORDER BY field1, field2;- Hide quoted text -

- Show quoted text -