grouping by address

[jaybo]

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.

 

[ScottGem]

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

 

[jaybo]

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 !

 

[ScottGem]

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

 

[jaybo]

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