Stripping out duplicate customers

[Shawn Johnson]

Hi
I have reports that are based on a table of customer records. The report
groups the customers then streets then lists the customers that live on the
street sorted by civic number. The problem I have is that some customers
are listed 20 or 30 times. The reason for this is that each record is a
different phone number, basically a list of phone numbers with the customers
that are assigned the phone numbers. For the most part one phone number =
one customer record but in some cases I have the same customer that has many
phones with different phone numbers at the same location. For example
"Local hospital" is listed 30 times because it has 30 phone numbers.

I need a query that will somehow group these customer records together so
that I only see the customer listed once for a particular civic address
location. Also to throw something else into the mix the customer name is
not always exactly identical sometimes you'll see something like this

1 record = hospital xray room 44 Main St
2 record = hospital cafeteria 44 Main St
3 record = hospital emergency 44 Main St
4 record = hospital ambulance 44 Main St

I'm a bit of a newbie to Access. Any help would be appreciated.

Shawn J

 

[Guest]

If you're doing a grouping in your query then don't use the field that causes
the duplicate or use a max or min value for that field, that way it will only
list one time. If you're not using a query, maybe you should.

 

[Shawn Johnson]

What about the senario I spoke about where the one customer has slightly
different variations of the same customer name? Is there anything I can do
about that?

 

[Guest]

that's where in you grouped query you want to use min value or max value. It
will give the minimum/maximum value of the list so in you scenerio below you
would get | hospital xray room 44 Main St | by using max value in the
name field.