Combining check boxes into a report

[rotorheli]

Hello,

I have a form where users can select different checkboxes for different maneuvers they've done, e.g.

[ ] Full down autorotations
[X] 180 Autorotations
[ ] Stuck Pedal
[X] Rapid descent with power

...etc.

I'm creating a report that only needs to display the maneuvers that have been checked, and display it in one sentence. For example, the above checkbox scenario I gave - the sentence would read something like, "Maneuvers completed: 180 Autorotations, Rapid descent with power."

I've tried searching for a solution to this, but keep meeting difficulties and my own experiments haven't worked. Anyone have any tips on how to combine only the checked boxes into a report?

Thanks!

 

[dkinley]

This is probably going about it the long way but it is a work around - in your query builder for the column you could use an IIF statement.

Here is an example for two columns ...

MNVR1: IIF([FieldName1] = -1, "Maneuver 1 Name", "")
MNVR2: IIF([FieldName2] = -1, "Maneuver 2 Name", "")

Then on the report for your text control in the data property ...

= [MNVR1] & ", " & [MNVR2]

Now this will show that comma in there if there that field is not checked so looking at alot of IIF's to eliminate the comma.

= IIf([MNVR2]="",[MNVR1] & ", " & [MNVR2],[MNVR1])

Again .. a long workaround. Only other possible way I can think of is calling a recordset and cycling through the field values, but I've never evaluated fields like this in trying to work a solution in this manner (I've done it for one or three columns only in a query so never needed to).

-dK