Curious blank column appears in crosstab query.

F

Frank Martin

I have a crosstab query which is returning a blank (null) column with a
heading of " <> ".

I have never seen this before.

Please help, Frank
 
A

Allen Browne

This column is generated where some records are null in the field used for
the Column Headings.

If you don't want to know about that column, you can exclude those records
from the query by adding this field to the query design grid a second time,
choosing WHERE in the Total row, and in the Criteria row:
Is Not Null
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Crosstab column data count 6
Query a crosstab query 2
Help on crosstab query 2
crosstab query column heading 2
Problems with Crosstab Query 4
crosstab - multiple values required 3
dynamic crosstab query 2
Multiple Parameter Crosstab query filter by form 1

Top