what is the mystery of "<>" in Cross-tab querry?

M

mezzanine1974

I produced a Cross Tab querry for a purpose. I need to create a second
querry by using Cross Tab fields. Unfortunately, I can not use field
which is named as "<>" in the cross tab querry, that is automatically
produced by Access.

Because, [CrossTab]![<>] is not valid because of "<" and ">" invalid
characters. And there is no way to edit "<>" in cross tab querry.

Is there any way?
 
A

Allen Browne

If there are any Null values in field you specified as the Column Heading
for your crosstab, Access creates an extra column to repsent the nulls, and
names it <>.
 

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

Querry link to Report 4
Forms with parameters to pass to cross-tab queries 3
Cross Tab Report Vs Dynamic coulmns 0
Substitute a querry for a table in ALL the forms in a large databa 2
Field Does Not Appear in Cross Tab 1
cross tab sort order 2
Want a Parameter for date range driving a cross tab query 2
CONCATENATE IN A TABLES? 1

Top