Yes/No Field showing 0 and 1

[simon4amiee]

I created a Pivot chart in Excel and when I have got the data from an Access Table, it shows my Yes/No fields as 0's and 1's. How would I get my Pivot data in Excel to show them as Yes and No's.

 

[Trevor G]

In the database you would need to change the properties of the Yes/No field so it provides you with Yes or No results, or change it to a lookup with a textbox with a Yes on 1 row and No on the other, that will get around your issue.

 

[gemma-the-husky]

are you sure its 0 and 1s

it probably ought to be 0s (false/no) and minus 1s (-1) (true/yes)