Yes/No fields shown only if yes

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

Guest

Does anybody know of a way to have a report only display the yes, no fields
that have been answered yes for each entry. For example: Say on a form, the
person is asked to select all that apply from a list of activies. The three
possible activities are: "Created Report," "Held Meeting," and "Discussed
with Director." Entry one did all three, entry two only held a meeting. I
would want them to display as follows:

Entry 1: Activities Completed: Created Report, Held Meeting, Discussed with
Director

Entry 2: Activities Completed: Held Meeting

In other words, instead of listing the name of the field at the top, and the
check boxes, it would say "Activities completed" on top (I know how to do
that part. I don't need help with that) and list the field names (in this
case, the activity) for the yes/no fields checked yes and simply not display
those checked no (that's the part with which I need help). Is this possible?
If so, is there an easy way to achieve this, or is it more trouble than it is
worth?
 
If I understand correctly, you can use a text box with a control source
like:
=IIf([Created Report],"Created Report",Null) & " " & IIf([Held
Meeting],"Held Meeting",Null)...etc....

You should consider normalizing your table structure. Adding more activities
should not require changing your table structures.
 
Wow! Thanks a million! That worked wonderfully! You have been a big help.

--
Have a nice day!

~Paul
Express Scripts,
Charting the future of pharmacy
 
Back
Top