CrossTab Query How Do I change Column Headings...

M

Muse

I have a cross tab query that has as its column headings a checkbox field.
Instead of displaying 'Yes/No' in the column heading it is displaying -1 / 0
which I think is how it is actually stored in Access. Is there anyway I can
get it display Yes/No values as my column headings.
 
V

vanderghast

Edit the query in SQL view, spot the PIVOT key word, change

PIVOT fieldName


into


PIVOT iif(fieldName, "Yes", "No")





Vanderghast, Access MVP
 
M

Muse

Works like a charm. Thanks!

vanderghast said:
Edit the query in SQL view, spot the PIVOT key word, change

PIVOT fieldName


into


PIVOT iif(fieldName, "Yes", "No")





Vanderghast, Access MVP
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 do I freeze the swimlane headers? 0
Crosstab column data count 6
CrossTab Combining 2 fields into Column heading 1
Crosstab Query: Column Headings! 2
Column headings in a crosstab query 1
Problems with Crosstab Query 4
Maximum Number of Crosstab Column Headings 2
crosstab query column heading 2

Top