CrossTab Query How Do I change Column Headings...

  • Thread starter Thread starter Muse
  • Start date Start date
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.
 
Edit the query in SQL view, spot the PIVOT key word, change

PIVOT fieldName


into


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





Vanderghast, Access MVP
 
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...
 
Back
Top