Absolute Value on Report

  • Thread starter Thread starter Jim
  • Start date Start date
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.
 
Hi Jim.
The other suggestion will work, however the following
would be better:
Abs([YourCheckbox])
If you use it in a summing querry, you could enter:
"AttendEvent1:Abs([YourCheckbox])"
in the field box without the quotes, and sum in the total
box.
Hope this helps.
Fons
 
Back
Top