Hello all,
I have a pivot table linked to an Access database. One of the pivot fields is based on a Yes/No (True/False) field in the database. The problem is, when it comes across to the pivot table it's shown as 0 or 1. Now, some of the users are getting confused (understandably) in trying to work out what they want. Does anyone know how I can convert this to a Yes/No without changing the field in my Access database?
I've tried formatting the number of the field with this:-
No;-;Yes
but I'm getting an error.
Any ideas greatly appreciated,
Dan
I have a pivot table linked to an Access database. One of the pivot fields is based on a Yes/No (True/False) field in the database. The problem is, when it comes across to the pivot table it's shown as 0 or 1. Now, some of the users are getting confused (understandably) in trying to work out what they want. Does anyone know how I can convert this to a Yes/No without changing the field in my Access database?
I've tried formatting the number of the field with this:-
No;-;Yes
but I'm getting an error.
Any ideas greatly appreciated,
Dan