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
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