Query for a report

[gobble]

I have a field called SCE on a form which you can select No or Yes. This field is also pulled through on a report. The report is based on a query, however I want the report to display "SCE" if the field is Yes and nothing if it is No. How would I incorporate this into the query? Or would it be best done in code?

Thanks

Juls

 

[SgtJarrow]

This will work in the query if that is where you want it...

In Field box of query where you have SCE of whatever tbale:

place in Field Line YesOrNo: IIf([SCE]=True,"Yes","No&quot
Remove any table name below it

Let me know if you have any questions. Enjoy. %-) There is no I in team.

Robert L. Johnson III, A+, Network+, MCP
robert.l.johnson.iii@citi.com