Cross tab query problem

[Guest]

I have a cross tab query that has PIVOT(x)
x can contain nulls
When I run the query in the designer, I get a column for the null values
with a heading of "<>"
When I run a report with this query as the record source, the column for the
null values is missing entirely.
I'd like this column to be on my report.
Is there an easy way around this?

 

[Jack MacDonald]

You can specify the exact columns to use int the cross-tab. for
example, here is the SQL of a crosstab query

TRANSFORM Count(aTblCities.CityName) AS CountOfCityName
SELECT aTblCities.ProvStateID
FROM aTblCities
GROUP BY aTblCities.ProvStateID
PIVOT aTblCities.ZoneID In (1,2,3);

will generate only three columns labelled 1, 2, and 3

If you right-click the query when in design view, you can choose
"Properties" to set the query's properties. One of which is Column
Headings

I have a cross tab query that has PIVOT(x)
x can contain nulls
When I run the query in the designer, I get a column for the null values
with a heading of "<>"
When I run a report with this query as the record source, the column for the
null values is missing entirely.
I'd like this column to be on my report.
Is there an easy way around this?

**********************
(e-mail address removed)
remove uppercase letters for true email
http://www.geocities.com/jacksonmacd/ for info on MS Access security