<> Field Heading - crosstab

[micang]

Access 2003

Hi All,

Sometimes when a crosstab is created in Access, it creates a field with the following as it's heading <>

Can anyone explain what this is?

I tried to search for the answer online, but no luck.

Many thanks

Michael

 

[PHV]

I guess your crosstab uses outer join and "<>" means Null.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[micang]

Hi PH,

Thanks, I do think it's got to do with nulls. I am crosstabing a flat table, no joins, but I think it means there must be some null values.

Thank you for your input.

Michael

 

[dhookom]

If you provided the SQL view of your crosstab, we could tell you which field in your table contains nulls.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[micang]

Hi Duane,

This is the code that creates the crosstab:

TRANSFORM Count(dbo_ni_used_sales_2006.unique_id) AS CountOfunique_id
SELECT dbo_ni_used_sales_2006.Make_Code, Count(dbo_ni_used_sales_2006.unique_id) AS [Total Of unique_id]
FROM dbo_ni_used_sales_2006
GROUP BY dbo_ni_used_sales_2006.Make_Code
PIVOT dbo_ni_used_sales_2006.Year;

Thanks for you help.

Michael

 

[dhookom]

If you are getting a column heading of <> then it suggests you have null values in your [Year] field.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[micang]

Thanks Duane, much appreciated.

Michael