J
Jim
I have a table for events where each record (person) can
be marked for any number of 6 events (yes/no). I wanted a
report that would print total attendance for each event.
I built a summing query since a "yes" has a -1 value. I
used this query to build a report and it works except the
totals are all negative numbers. How do I have them show
as positive numbers? What formula do I write? Do I put
it in the query or the report? I have tried the formula
=Abs([SumOfEvent1]) everywhere I could think of and when I
run the query or report I get a "Enter parameter value"
Help would be greatly appreciated. The report is correct
information wise but is embarrising to distribute because
of the negative numbers.
be marked for any number of 6 events (yes/no). I wanted a
report that would print total attendance for each event.
I built a summing query since a "yes" has a -1 value. I
used this query to build a report and it works except the
totals are all negative numbers. How do I have them show
as positive numbers? What formula do I write? Do I put
it in the query or the report? I have tried the formula
=Abs([SumOfEvent1]) everywhere I could think of and when I
run the query or report I get a "Enter parameter value"
Help would be greatly appreciated. The report is correct
information wise but is embarrising to distribute because
of the negative numbers.