Hey all, I want to create a page that displays like a report generated in access. I believe the coperate style, with a hierarchy system. For those who dont get me. I Have 2 main tables that I want to split my lay put by.

Location and House.
Location consists of 4 contents

and there are a number of Houses falling under these locations.

I want a lay out that will print the Location
and then for each house print whats in it and then move on to the next house and then move on.

How do I do this? i like the layout in access, but I cant get the code. I am using asp with VB

You'll probably have to rewrite the layout entirely in HTML and ASP...