Can this be done...?

[Arnold Osborn]

I am doing a report that I am trying to format a certain way and I am curious if this is even possible... any help or insight would be wonderful. THANKS.

In my table I have a drop down selection of three options:
Branch
Division
or Both

What I am currently getting on my report is this...

This occurred at the (Branch, Division, Both): BRANCH

Even though this is fine... I am being asked to do it this way...

This occurred at the X Branch, __ Division, __ Both

Where instead of putting in the answer, they want the box checked next to the appropriate selection.

HELP.. can this be done? Thanks so much

 

[antomack]

Set the following as the control cource of the field in the details section of your report.

To get one overall line use
="This occured at the " & IIf([aa]="branch","X","_") & " Branch " & IIf([aa]="Division","X","_") & " Division " & IIf([aa]="Both","X","_") & " Both"
Example
This occured at the X Branch _ Division _ Both

else for three seperate results set three fields to one of each of following.
=IIf([aa]="branch","X","_") & " Branch "
=IIf([aa]="Division","X","_") & " Division "
=IIf([aa]="Both","X","_") & " Both"
Example

This occured at the     X Branch       _ Division        _ Both