Recent content by gpo

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

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 "...