Query containing records from a table, less the dupliates

[crowegreg]

How do I create a query containing records from a table, excluding any duplicate records within that table?

[June7]

Which record do you want - the most recent?

Or do you want just one field and not show duplicate values?
SELECT DISTINCT [fieldname] FROM tablename;

Or do you want to summarize data?
SELECT Account, Sum(Amount) As SumAmt FROM tablename GROUP BY Account;

[crowegreg]

Thanks for replying.

I'd like for any of the duplicates to not appear in the query.

Example Table data:

ID Number:
53
56
53
56
59
30

Query results:
ID Number:
59
30

[June7]

You want only where the count = 1.

Try

SELECT ID FROM tablename GROUP BY ID HAVING Count(ID)=1;

[crowegreg]

Thank you. Exactly what I need!!