How to use SELECT DISTINCT command

[gpo]

I've got an access table and I want to query a table that shows no duplicates postcode.
Therefore, I want to use the SELECT DISTINCT command in access. But it don't
work.
How is it done in access?Any help is welcome!

Table:House
column1 : name
" : DOB
" : postcode
" : address

 

[pbaldy]

Not sure why you posted in the SQL Server forum then, but:

SELECT DISTINCT Postcode
FROM House

 

[gpo]

DISTinct command

Thanks for the reply ,but the I've tried that in access and it didn't work.
why?

 

[pbaldy]

Don't know, as it should. Can you post a sample db? That's not all in one field, is it?

 

[pdx_man]

Try this:
SELECT DISTINCT TRIM(Postcode) AS Post_Code
FROM House

What is your datatype for Postcode?
Be sure that it is DISTINCT and not DISTINCTROW. There is a difference.