I just threw together a DB with 1 Table and 1 Query to see what I could come up with.
Table1 only has 2 Fields: Card and Numbar (Number), both of which are Long Integers. There is no Primary Key nor any Indexes.
The Query's SQL was as follows:
Code:
SELECT DISTINCT Table1.Card, Table1.Numbar
FROM Table1;
This Query appears to do exactly what you want, although if there are other Fields in the database that are being returned as well, that could throw off the Query.
the DISTINCT keyword in a SQL Query affects the entire Query, so as you add Fields to your Query, it increases the number of potential duplicates. For example, if you're only querying those two fields, DISTINCT will do what you want. If you add a third Field to the Query however, you can get results like this:
Card Number ThirdField
1 1 1
1 1 2
1 2 1
1 2 3
2 1 3
2 1 4
Notice that the Card and Number fields repeat. This is because the ThirdField Field makes the combination unique from the others.