Well if you don't know how many people are in a household it will be difficult thus also depending on the db you are using. So assuming you just use Microsoft Access and you only want to consider a max of 2 people in a household you could do something like
SELECT
First(FirstName) AS FirstName1,
Last(FirstNa me) AS FirstName2,
First(LastName),
Address1,&nb sp;
Address2
FROM
addresses
GROUP BY
addresses.Address1,
addresses.Address2;
|
Then in your vbcode you can do a simple
If rs("FirstName1") = rs("FirstName2') then varFirstName2 = ""
If you are using MSSQL or so you can do it better using a sproc, let me know.
Topic Options
Post Options
Thanks(0)
