Returning the Yes/No value in a report

[canjfn]

I have a table with a number of yes/no fields; this table is used as a source for a query,

Now when writing a report based on this query, the respective fields return -1 for where I have said Yes and 0 for No, how can I make the fields on the report say “Yes” or “No”

I was trying to do something like this (Text88 being an unbound field)
If Me.[Cyclic_Loading] = "0" Then
Me.Text88 = "NO"
Else
Me.Text88 = "YES"
End If
when opening the report but it does not work

It says, “ you have entered an invalid expression” and has highlighted this line
If Me.[Cyclic_Loading] = "0" Then

Thank you

 

[ColinEssex]

Use this in the query

IIf([FieldName] = -1, "Yes", "No")

Only text is put in quotes " ", numbers are not

Col

 

[canjfn]

Thank you, now works fine

 

[Rich]

You could also just have set the display format to your textbox to Yes/No