Many People to Same Address

[Robert M]

I have been working on a query to list all the people that go to the same address. I works pretty well, however I come accross addresses that have a suite or apt number that is included with the other addresses.
I.E.

Joe, 1st St, Apt b, Anytown, ST, 99999-9999
Flo, 1st St, Apt b, Anytown, ST, 99999-9999
Dan, 1st St, Apt q, Anytown, ST, 99999-9999
Bob, 1st St, Ste 8, Anytown, ST, 99999-9998

I have tried the "Find Duplicate" query for Zip; Zip, Address 1, Address 2; Address 1; Address 2;
Even breaking down the order via Zip, Address 1, Address 2; or Address 1, Zip, Address 2; or Address 2, Address 1, Zip
I am not able to get the single address to mutiple names, done properly.

Does anyone have an Idea on how to do a VBA Program for this?
Or a proper query or queries?

Thank you for your time and patience with this Project.

Robert M

 

[SpentGeezer]

Greetings and salutations,

You need to provide more information on how the address data is stored (e.g. table names and what data is in those tables) also how you have created you query etc..

Describe your database and how it works.

Thanks,
Spent

 

[jdraw]

As Spent has said we need more info on what you are storing and how your database is intended to work.

Also, your Find Duplicates should find Joe and Flo - they have exactly the same address info (from your example data).

For things to be duplicates, the values of all fields in the query must be the same.

 

[Robert M]

Thanks for your replay jdraw and SpentGeezer. However, I have solved the problem. It was not a query I needed to set but a form. What I have done is create a Form within a Form with the Master and Child links being [Address 1]; [Zip].
The Main form has the fields [IDNum], [Address 1], [Address 2] and [Zip]. The SubForm has [IDNum], [Name], [Address 1], [Address 2], [City], [State] and [Zip]
When the [IDNum] is entered in the Combo Box in the Main Form, the subForm displays all the [Address 1] and [Zip] records that match the [Address 1] and [Zip] fields associated with the [IDNum] requested.
So far I have not found any errors in this solution.

Thanks for your time with this project.

Robert M

 

[jdraw]

Glad you have it resolved.

 

[SpentGeezer]

Well done my Liege