If statements in text boxes on reports??

[Mermogoat]

In my query that is the Report's RecordSource, I have a field of the Yes/No type that is connected to a checkbox on a form. On my report, if I have it display that field, all i get is a 0 or -1 for True(yes)/false(no). Is there a way to have, as a text field's ControlSource, some kind of If/Then statement like

If [Complete]=0 Then Value="Yes" ElseIf [Complete]=-1 Then Value="No" ??

Thanks

 

[Rich]

Change the display format to Yes/No

 

[Mile-O]

If [Complete]=0 Then Value="Yes" ElseIf [Complete]=-1 Then Value="No"

Also, use an IIf() statement to tidy it.

IIf([Complete] = 0, "Yes", "No")