Boolean and Text

[stu2010]

Hi there a really basic question regarding boolean and text fields. What is the simplest way to set text into a field depending on the value of one or more boolean fields in the table? I am trying to create a text field of true when two fields = 1. Needs to be in text format so it can be exported clearly to Excel as words rather than numbers.

Copy of database attached.

Test_Tag_Mod3working.fp7.zip

[Vaughan]

"I am trying to create a text field of true when two fields = 1"

Case(

field1 and field2 ;

"true"

)

If you just wanted a boolean result, then this would do the trick:

field1 and field2

In my experience, Excel makes its own mind up about what is text and number.

[comment]

I see that numbers formatted as Boolean export to Excel in the same way.