This begs to ask if you're managing residences or occupants. Your
explanation suggests residences and so your data needs to be sortable
by address.

The result sample you posted does make any sense to me. If managing
occupants then would simply filtering by residence address serve your
needs? Or would a Pivot Table be a better way to go?

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion