Adding items in the group and...... 1

[b31luv]

I set up this report from a query. In the Query there is a MAIN ITEM NUMBER. IE 22, 23, 24. Each MAIN ITEM NUMBER has anywhere from 1 to 15 OPTIONS and a user may use all 15 or just one. My form is setup so that each OPTION has a heading IE 22.1, 22.2, 22.3,....22.k. What I would like to do is count all of the OPTIONS chosen for each MAIN ITEM NUMBER and use in my IIF statement.

IIF("the number of options chosen" > 1, "Comments:", "Comment:&quot

I think I've tried everything, so hit me with your best shot.

 

[PaulBricker]

If you have a group for the MAIN ITEM NUMBER then in the Group Footer put
IIf(Count(*)>1,"Comments:","Comment:&quot

That may do it.

Paul

 

[b31luv]

Thanks Paul, that works beautifully.