How do I rid myself of the "<>" column in a crosstab. What is that column called? Why is it there?

Dsastray
Dsastray used Ask the Experts™
on
When I do a crosstab query on a certain table, I get a "<>" column in addition to the expected column headers. Why? What is this column called? What is it about the particular structure of this query that elicits this?

This is driving me bonkers. Especially given that I can't search the internet for "<>" ("Your search - "<>" - did not match any documents.").
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Top Expert 2010

Commented:
Please post the SQL statement for your crosstab query.  You can get it by switching to the query's SQL view.
MIS Liason
Most Valuable Expert 2012
Commented:
Then you have a record in your table with a blank Column Field.

For example, in your crosstab query, your Row Field is "Supplier" and your Column field is "Category"
If you have a record in the table with no value in the "Category" field, you will get this: "<>" Column...

(Note, the value in the <> field should give you some indication of the odd record.)

Here is a sample.
Notice that in the source table, ProductID "78" (the value in the <>Column) has no value for CategoryID (the Column Field in the crosstab query)
In the source table, if you enter a 3 in the category field for ProductID 78 , you will see that the "<> Column disappears... when the crosstab query is re-run

;-)

JeffCoachman
Access-EEQ-26574399--NotEqualToC.mdb

Author

Commented:
Aah, very interesting. Thank you for the illustrative link! Helping me understand that helped me eliminate some rather ill-behaved data from my table.

Author

Commented:
thanks!
Jeffrey CoachmanMIS Liason
Most Valuable Expert 2012

Commented:
;-)

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial