Following your model I created a select query as follows but I get the
message that my statement contains a reserved word of has a spelling error or
the punctuation is incorrect. I tried changing to square brackets around
Name and adding square brackets around the table name but I got the same
error message.
Can you see what I've done wrong ??
SELECT; First(NAME), [UNIT_NUMBER], [STREET_NUMBER], [STREET_NAME], [WARD]
FROM PSSupporters
GROUP BY [UNIT_NUMBER], [STREET_NUMBER], [STREET_NAME]
Marshall Barton said:
FJ said:
I have a database listing the names and addresses of people. There are often
several family members living at one address. I want to end up with a list of
addresses without duplicates. The addresses are in 3 columns. Unit#, street
# and Street name.
How can I eliminate the duplicate addresses?
SELECT First(namefield), [Unit#], [street #], [Street name]
FROM sometable
GROUP BY [Unit#], [street #], [Street name]
Note that using First just picks a relatively random name
from the people at the same address. If you want to use a
specific name then your table will need a field to indicate
which records contain the name to use.