Problem with simple columnar report

[KerryL]

My database has a table called "tblRegionList" which assigns each county within the state to one of 8 regions. The table contains just two columns: County and Region, and for each county there is a corresponding region number.

I'm trying to build a simple report that shows each Region number across the top of the page and lists under it the name of each county within that region, like this:

Region 1 Region 2
====== ======
Barry Calhoun
Waters Munson
Case Franklin
etc etc


I suppose I could manually build the report with text boxes, but I was hoping to have the correct list of counties appear under each Region heading automatically.

Sounds easy, but so far I've not been able to get it. Any help you can provide will be greatly appreciated.

KerryL

 

[RickSpr]

Interesting question. Perhaps you could lay out 8 subreports, one for each region, giving each subreport a query that selects just the counties for that region. Each subreport's detail section would contain just the county name field. You could even get them sorted this way. Rick Sprague