Boolean pivot table field

dk · Apr 30th, 2002, 07:14 AM

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

Mark W. · Apr 30th, 2002, 07:55 AM

Format as...

[=0]"FALSE";"TRUE"

Or...

[=0]"No";"Yes"

dk · Apr 30th, 2002, 08:27 AM

Cheers Mark, that did the trick. I had a funny feeling you'd be the one to reply.

Thanks again,

Dan.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 30th, 2002, 07:14 AM	#1
dk MrExcel MVP Join Date: Feb 2002 Location: Sydney, Australia Posts: 2,908	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

Apr 30th, 2002, 07:55 AM	#2
Mark W. MrExcel MVP Join Date: Feb 2002 Location: Austin, Texas USA Posts: 11,654	Format as... [=0]"FALSE";"TRUE" Or... [=0]"No";"Yes"

Apr 30th, 2002, 08:27 AM	#3
dk MrExcel MVP Join Date: Feb 2002 Location: Sydney, Australia Posts: 2,908	Cheers Mark, that did the trick. I had a funny feeling you'd be the one to reply. Thanks again, Dan.