Crosstab Column Headings and "0" for null values

[cdnicholson]

Hello -



I have a simple crosstab query:

Field: Operator
Total: Group By
Crosstab: Column Heading

Field: Driver
Total: Group By
Crosstab: Row Heading

Field: Cat1
Total: Group By
Crosstab: Row Heading

Field: DriverAging: Nz(Avg(Date()-[tbl_drivers].[relstartdate]),0)
Total: Expression
Crosstab: Value

First problem... all the column headings are reflecting "Aging", not the Operator value

Second problem... The results are producing "0" for null values if SOME of the values in the row or column are null, but if ALL of the values in a row or column are null, that row or column is missing. And since all the column headings are "Aging", not the Operator value, I have no idea which Operator has no Drivers...


Thank you in advance for any help you can provide.

[June7]

If you want to provide db for analysis, follow instructions at bottom of my post.