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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Using abs in reports 1
Absolute Value on Report 2
Report made of a query cross table 5
Calculating Absolute Value 3
Cross Tab Report Vs Dynamic coulmns 0
update cross tab query in a report 7
query to count yes/no fields amounts 11
Access Report Average Miles/Gallon in Group Footer and Report Footer? 9

Back
Top