Two Activity Flags on page, cannot show both at same time.

Pete Marler

11y1kSQL

Good afternoon

I have to two activity flag fields on one page, which are tick boxes.

I have written a formula for a report to show when the boxes are ticked.

If {TBLITEM.ACTIVITYFLAG} = 1152 Then

"Positive Test"

else

If {TBLITEM.ACTIVITYFLAG} = 2176 Then

"Positive Result"

This works fine if one or the other box is ticked, but will not work when both boxes are ticked (as they will sometimes need to be).

Can anyone help solve this so that I can tick both boxes and they will show up on the report?

5 Replies

Know the answer? Post it — somebody with the same question will find it here.