I have a database with a query and reports like yours. What I have are CheckBoxes for things like WARRANTY, CLOSED and so on. Based on what I have set on my report I would suggest this for yours:
Place your CheckBoxes in the Report and Hide Them..(Properties/Format/Visible=No)
Place a TextBox on the Report wherever you like and set it's ControlSource to this below:
This will show Missing OR Off, and will cover
This code will show Missing OR nothing at all. This you would set for each CheckBox if you have one two for each line item. Any more than that you will just need to do a full all out IF..THEN..ELSE statement.
Pick and choose, try them out and see what you get. Hope this helps you out.
iif statements are basicaly boolian (i cant remeber how to spell that) meaning that they only return true or false. You can name true or false anything you like... whatever you put in will display as the field value.
nameOfExpression can be anything you want the field name to appear as.
= sign can be any operator <, >, =<, Like, between you get the idea.
you dont need to put a semicolon at the end of the statement.
if you are building an SQL string the synthax is slightly different and should appear before the FROM part of the statement:
iif([fieldName] = value, true, false) AS nameOfExpression
Note that SQL treats this as a field so dont forget to use commas where nessesary (before and after depending on the situation).
You can add as many of these fields as you want and reports will treat them as valid fields so you dont need to code anything.