Is there a way to Have a YES/NO Fie

[cell0042]

Is there a way to Have a YES/NO Field Type but if you check yes on the form it would print out whatever the field is on a report.

For example:
IF you have a field called "Late". On Your form there will be a box to check. Then on your report you want it to print the word "Late" rather then YES/No. Even if you made a query that printed out everyone who was late it still would only print yes or no.

 

[chrissie1]

in the query use this

latecall:iff(late=true;"late";"&quot

put this in the place where you normally put the fieldname
"What a wonderfull world" - Louis armstrong