How to test for Yes/No in a report?

[JustAnElf]

Greetings One and All,

I have built a report that I really like. It shows what documents a user has filled out when they complete a different MS Access form. The text of the report version looks like this.

Report1
UserName Document1 Document2 Document3
User 1 Yes No Yes
User 2 Yes Yes Yes
User 3 No No No

I now want to add a 4^th column to the report titled Completed. If the user has answered yes to all three fields (Document1, Document2, and Document3) then a value of Yes would be displayed under the Completed field. The report would look like this.

Report1
UserName Document1 Document2 Document3 Completed
User 1 Yes No Yes No


User 2 Yes Yes Yes Yes
User 3 No No No No


How do I get the MS Access report to sum the Yes’s going horizontally? If I were to guess I need to add a new temporary field to the report called Completed and then somehow do a True/False test with the Document1, Document2, and Document3 fields. Sadly, I’m having trouble figuring out what that test would be. Any suggestions? If it helps, all of the fields are in the Detail section of the report.

[NTC]

put the logic for 'Complete' in the query that is the record source for the report.

the technique to use is the IIF statement..... Bing about on IIF in queries and you'll see alot of examples...it is very useful

[JustAnElf]

Excellent. Thank you for the advice and leading me in the right path. I did what you suggested and figured out how to use the IIF statement. The report works beautifully with the new column.