When I use FORMAT([table or query name]![fieldname],"hh") as a Column 
Heading in a crosstab query, null values of [table or query name]!
[fieldname] are collected into a separate "<>" column.  This works well as 
a way to show that the value is unknown.

The overall purpose is to create a crosstab query with hourly counts or 
totals.

However, there seems to be no easy way to further manipulate the "<>" 
column.  Even the column name is ambiguous.  It can't be represented by 
[<>].  How can I further manipulate the so called "<>" column?

You can use this IIF statement to remove your unwelcome "<>" Heading
In the "Field Name" section in your query add the following code

IIF(IsNull([fieldname]), "Unknown",[fieldname])

Good Luck,
Derrick Flores
San Antonio, Texas

----- Original Message -----
From: "Rand E. Gerald" <rgerald@u...>
To: "Access" <access@p...>
Sent: Tuesday, November 26, 2002 11:03 PM
Subject: [access] Crosstab Columns


> When I use FORMAT([table or query name]![fieldname],"hh") as a Column
> Heading in a crosstab query, null values of [table or query name]!
> [fieldname] are collected into a separate "<>" column.  This works well as
> a way to show that the value is unknown.
>
> The overall purpose is to create a crosstab query with hourly counts or
> totals.
>
> However, there seems to be no easy way to further manipulate the "<>"
> column.  Even the column name is ambiguous.  It can't be represented by
> [<>].  How can I further manipulate the so called "<>" column?