Formatting True/False for export to Pivot

[Yoplumpy]

Hi All

I have a table holding the data I need and this has quite a few yes/no check boxes. I am planning on connecting this as a datasource in Excel - with a pivot table to summarise the data.

The table shows 0 for false/no and -1 for true/yes. When connected to Excel they show as FALSE/TRUE.

Is there a format function I can apply in the table to turn these into numbers so that False is 0 and True 1 - then these can be summed in the pivot..

Any guidance would be great.

Cheers

Paul

 

[DCrake]

Create a query based on your table and in a column for the true/false enter

AliasName:IIF(Field=True,1,0)

 

[Yoplumpy]

Thanks very much David - your help is appreciated.

Paul

 

[MarkK]

Or, since Field is already boolean you don't need to compare it to a boolean ...

AliasName: IIF(Field, 1 , 0)

Or simpler and probably quicker ...

AliasName: Abs(Field)