Any Help would be greatly appreciated.

I have a report that has a field for a housing provider and then the address of the building. A provider may have many unit at one address.In my report I want them to group together (roll up) if the have the same address. Instead the report lists every address regardless. I've grouped by address, what else do I need to do.

Can you give some examples of what the address field contains? There has to be an exact match. For examples:

123 Elm St Apt 12
will be different from
123 Elm Street Apt 21

They are exact matched thats whats troubling me, Every field lines up the only variance is in the unit number which is a seperate field and not included. So one housing provide say John smith has 4 different units all 1 bedroom with the same features at one address 10 willow, willow appears in the report 4 times!!

Any ideas and thanks for replying !

Can you attach a sample of your database? I'd have to see if to figure what might be the problem.

I figured it out poor choice of summing on my part thanks for responding