J john Dec 26, 2003 #1 Hi How does one count multiple t/f fields for a positive value in a single query? john
D Duane Hookom Dec 26, 2003 #2 Since this is a reports NG, I assume you want to do this in a report and you have a field with a name like [FldTrueFalse]. You can add a text box to a group or report footer with a control source of: =Abs(Sum([FldTrueFalse]))
Since this is a reports NG, I assume you want to do this in a report and you have a field with a name like [FldTrueFalse]. You can add a text box to a group or report footer with a control source of: =Abs(Sum([FldTrueFalse]))
