Crosstab - Grouping headers in Access 97

[GinaStar]

I have a crosstab query/report with dynamic headers that doesn't quite do what I want it to do. The report works great for showing *all* of the units for the county, but I want it to just show the units on each particular county. Have searched faqs and done search here and elswhere online. Any advice anyone? Crosstab shows all info needed in report, but I want it to break crosstab headings by job:

c=County Name rowheader
n=Project Name rowheader
p=Product Hauled rowheader
u=Unit ColumnHeader

sorting/grouping set to
county header/footer=yes
product header/footer=yes

layout is:
county header: no values - if can get rpt to work will add county name
product header: Units
Detail: counties/bodyfields
product footer: totals
county footer: no values - if can get rpt to work will add grand totals

What it is doing:

        u1  u2 u3/4 u9A  uA  uB
c1n1p1  1        2   1  
c1n1p1           1   1
total   1        3   2
        u1  u2 u3/4 u9A  uA  uB
c1n1p2               1
c1n1p2  1            1
total   1            2
        u1  u2 u3/4 u9A  uA  uB
c2n1p1      1             1   2
c2n1p1                    1
total       1             2   2
        u1  u2 u3/4 u9A  uA  uB
c2n1p2      1             1   1
total       1             1   1

what I want it to do:
        u1  U3/4 u9A u11
c1n1p1  1     2   1   3
c1n1p1        1   1   1
total   1     3   2   4
        u1  u3/4 u9A u11
c1n1p2            1   
c1n1p2  1         1
total   1         2

        u2 uA  uB
c2n1p1  1  1   2
c2n1p1     1
total   1  2   2
        u2 uA  uB
c2n1p2  1  1   1
total   1  1   1

problem is, the unit numbers on the stockpiles may change for each county, so I cannot use the fixed headers and I've not found instructions clear enough (ok, so I'm stupid) to figure out how to set up a table to use for the headers. I may have at the most 15 units on one county, so I have set up plenty of unbound columns. I just don't know how to get it to limit the columns to just that particular county in the report. Right now, I'm using a report set up like the one in the Solutions.mdb database where it fills in the data from the crosstab. I figure it's something simple I'm missing, but it's driving me crazy!! This is a continuous report that may have as many as 10+ counties and I want it to fit on the page properly. As it is now, if I run it with all counties and each has 15 units..150+ columns? I don't think so!

Thanks for any input
Regina (who feels incredibly stupid right now!)

 

[dhookom]

The Crosstab Report example at

http://www.invisibleinc.com/divFiles.cfm?divDivID=4

does exactly this. Each "County" can have any number of columns and they can all be different from othe counties.

Duane
MS Access MVP