Select unique records (members per household) in access
Posted on 2014-09-30
I need to select unique records from a table in access. Setup first.
My table design is as follows - all text fields.
Mailing Zip/Postal Code
I need to get only one full mailing address (First Name, Last Name, Mailing Street, Mailing City, Mailing State/Province, Mailing Zip/Postal Code) per distinct Household Name.
Can I do this with a subquery?