Check Box in Query

[fenhow]

Hi, I have a query that has several checkbox fields. When I open the query it shows the checkbox not the value (see attached 1), when I export the data it comes into excel as TRUE and FALSE. Is there a way I can in the query show the value ie True or False and secondly add some code in the query that takes a True value and makes it say something else like "BOB" (see attached 2)
Many thanks,
Fen

 

[pr2-eugin]

Try using CBool function to change it to word TRUE or FALSE. Use an IIF statement to change the value to anything for True. Something like.

NewFieldName: CBool(yourOldFieldName)
AnotherNewField: IIF(NewFieldName = True, "BOB", "ROB")

 

[fenhow]

Perfect! Worked excellent.
Thank you.