One or more column headings in the query's results are labeled "<>".
Microsoft Access returns "<>" as the column name for any Null value in the field with Column Heading in its Crosstab cell. To avoid this you can:
- Explicitly define your column headings by setting the query's ColumnHeadings property. For more information, click .
- In the design grid, type Is Not Null in the Criteria cell of the designated Column Heading field.
- In the Criteria cell of the designated Column Heading field, use the Nz function in an expression that will convert Null values to a more meaningful value, such as "Unknown." For more information about the Nz function, click .