J
Jon H
Hi,
I have been given a database of Company names, addresses and associated
phone numbers. They require a simple report sorted by Company , but in the
instance that 2 or more companies have the same phone number they want one
line of the recordset showing all company names associated with that number.
Any company name listed in a duplicate is not to appear again further down,
even if the sorting might normally put it there.
To clarify,
Alpha Manufacturing
Bravo Manufacturing
Charlie Manufacturing all have the same phone number.
If we weren't worried about the duplicate phone numbers then Alpha would
appear first, and the other two would each be a long way down. What we want
is something like:
Alpha Manufacturing 123 Smith Street 555-1234
Beta Manufacturing
Charlie Manufacturing
Alpha Shoe Store etc etc
Beta and Charlie would not appear again.
Any help would be greatly appreciated.
Thanks
I have been given a database of Company names, addresses and associated
phone numbers. They require a simple report sorted by Company , but in the
instance that 2 or more companies have the same phone number they want one
line of the recordset showing all company names associated with that number.
Any company name listed in a duplicate is not to appear again further down,
even if the sorting might normally put it there.
To clarify,
Alpha Manufacturing
Bravo Manufacturing
Charlie Manufacturing all have the same phone number.
If we weren't worried about the duplicate phone numbers then Alpha would
appear first, and the other two would each be a long way down. What we want
is something like:
Alpha Manufacturing 123 Smith Street 555-1234
Beta Manufacturing
Charlie Manufacturing
Alpha Shoe Store etc etc
Beta and Charlie would not appear again.
Any help would be greatly appreciated.
Thanks