By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
444,027 Members | 1,313 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 444,027 IT Pros & Developers. It's quick & easy.

SELECT DISTINCT in access

P: 6
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 postcode FROM House 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
Sep 13 '07 #1
Share this Question
Share on Google+
1 Reply


MMcCarthy
Expert Mod 10K+
P: 14,534
Not sure why it didn't work but try this instead.

Expand|Select|Wrap|Line Numbers
  1. SELECT postcode 
  2. FROM House
  3. GROUP BY postcode
  4.  
Sep 14 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.