strip "similar" records from table

S

Shawn Johnson

I have a table that contains business customer records. The problem I have
is that when I print out a report that lists all these records some
businesses with multiple phone lines are in my table multiple times. For
every serparate phone line there is a separate customer record although it
is the same customer at the same address. Sometimes though there are slight
differances to the customer name , maybe a mispelling etc, so a "group by"
seems to be out of the question. What I would like to do is list the
business record once but provide an extra field with all the extra phone
lines listed which would be taken from the redundant records.

Can someone give me a suggestion or sample query / queries.

This is above my query building skills

Thanks

Shawn j
 
J

John Vinson

I have a table that contains business customer records. The problem I have
is that when I print out a report that lists all these records some
businesses with multiple phone lines are in my table multiple times. For
every serparate phone line there is a separate customer record although it
is the same customer at the same address. Sometimes though there are slight
differances to the customer name , maybe a mispelling etc, so a "group by"
seems to be out of the question. What I would like to do is list the
business record once but provide an extra field with all the extra phone
lines listed which would be taken from the redundant records.

Can someone give me a suggestion or sample query / queries.

This is above my query building skills

Thanks

Shawn j

I'd suggest using the Sorting and Grouping feature of the Report to
group by the unique CustomerID. Put customer specific information in
the Group Header, and the phone numbers in the detail section.

If you are grouping by customer name, and you have differences
(however slight!), Access will of course treat different names as
being different records. Computers are very literal minded; "Johnson
Industries Inc." and "Johnston Industries Inc." are two different
names, and - just looking at them - you have no guarantee that they
aren't in fact two different companies! Unique ID's are not optional.

John W. Vinson[MVP]
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top