Printing Yes/No in a Report

[Butterfli4]

Hi!
Im no guru at Access so I need some help from all of you experts!
Im printing a report which lists 10 training programs that each employee should complete. My main table has a column for each program and a text yes/no in each field. I want to make a report which prints all employees and has headers for all programs but only prints a "yes" under modules that have been completed. I can do a report for EACH program which prints who has and has not taken the courses, but Im not sure how to link those either so that both print in a report for each particular program. Confused yet??
Thanks for any suggestions!
Christy

 

[jimbrooking]

Hi Christy,

If I understand the problem, you have a table with 10 program names (Say "Prog??, where ?? = 01, 02,...,10) and for each program, another field (call it "Compl??", where ?? = 01, 02,...,10) containing "Yes" or "No" depending on whether the person has completed the program. Now you want to print in a report a "Yes" if the Compl?? field is "Yes", and print nothing if not.

If this is the problem, here's a solution for the field Compl00:

1. Define an unbounded text box where you'd like the "Yes" or Nothing to appear.
2. In the Properties for the text box, enter the following in the Control Source:
   =Iif([Compl00]="Yes","Yes","")
   [/list=1]
   Check out the online Help for the Iif function.
   
   HTH,
   Jim