Cross-tab Query

J

Jade5

Hello:
I have a cross-tab query (left outer join) that is the source for a list
box. There is a field that appears with these characters as the field name
<> What does this mean and how can I get rid of it?
Thanks,
J
 
P

Pieter Wijnen

It means your Pivot Column contains NULL values
you can either exlcude them by using a WHERE criteria (WHERE MyField IS Not
Null)
or by casting using Nz (Nz(MyField,'No Value')

HTH

Pieter
 
J

Jade5

Thanks Pieter.
J.

Pieter Wijnen said:
It means your Pivot Column contains NULL values
you can either exlcude them by using a WHERE criteria (WHERE MyField IS Not
Null)
or by casting using Nz (Nz(MyField,'No Value')

HTH

Pieter
Click to expand...
 

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

How to display zero value in blank fields of Cross Tab query 0
Remove title bar and phase bar by default on swimlane 0
Consolidation Table from Different Excel Tabs with Different Format 1
Cross Tab Report Vs Dynamic coulmns 0
Excel 2013: How to ensure a cell is not left blank by users? (Not using VBA) 0
Basing a report on an updated cross-tab query 2
How to set tabs in work document 0
Ordering of Cross Tab Query 7

Top