Crosstab Query and nulls

[ashley0578]

In my Accounts table I have a field called Status. This field is populated by single letters. A=Active, P=Paid and so on. I have a status (R) that is occasionally used. It won't show up in my crosstab queries since we currently do not have an account that is in R status. How can I get my crosstab to show the R status as having 0?

 

[Rich]

Use the column header property of the crosstab

 

[ashley0578]

I may not understand what you're saying but I already have a columns header for my Status. Please see attached screen shot.

 

[Rich]

Type the values into the column heading on the very property sheet that's shown in your picture A,P,R