I created a query to pull information from my table. The query is a crosstab and I am getting <> in a cell that has no information. I know what the problem is but can't figure it out.



Here is what I have in each of the crosstab:

(Year([DateofAudit])*4+DatePart("q",[DateofAudit])-1)
Group By

Qtr: (Format([DateofAudit],"q"" Qtr - ""yyyy"))
Row Heading

Letter
Table: QryConsentsforGraph
Group By
Column Heading

SumOfTotal: FindingTotal
Table: QryConsentsforGraph
Sum
Value

I think there is a problem with letter and SumOfTotal: FindingTotal, but I don't know how to show just the Letter which is just the Alphabet I input to correspond with an audit finding. Even if I put the letters A-H with a number value it (<>) will still show zero's just before the Alphabet.

Example:

Qtr ---------<> --A---B---C
1 Qtr - 2011 -0----0---2---2
2 Qtr - 2011 -0----2---2---2