Check Boxes in Report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello.

I have the following checkboxes in a form:[Disposition Other] [Disposition
Repair] [Disposition Rework] [Disposition Use as is]. In the report if
[..Other] is check I want have report print "O" for [...Repair];
"Rep", for [..Rework]; "Rew", and [...Use...]; "U". It is probably an iif
statement, but need a little help.

Thanking you in advance. Max
 
Hi Max.
You may want to consider instead using an option group rather than indvidual
check boxes, this would prevent multiple selections etc. and you can save the
selection as
"O", "Rep", "Rew", or "U".
If you insist using the multiple check boxes you can create a compound IIF
like:
=IIF([YourFieldName1] is yes,"O",IIF([YourFieldName2] is
yes,"Rep",IIF([YourFieldName3] is yes,"Rew",IIF([YourFieldName4] is
yes,"U","None"))))
All of the above on one line starting with the first =IIF, you need to
substitute your field names for the once I used.
Hope this helps.
Fons
 
Back
Top