There are may different methods, the one I would probably use is to just
quickly build a totals query for each of the three fields.  I would then
place each of these totals queries in the query you are using as the record
source for your report.  You can then just place the field from each of the
totals queries in the appropriate location in your report.

If you are using a query to get a total, and it gives you a parameter
prompt, often that's Access' way of reminding you that spelling counts!
Access asks you for a value (via a parameter prompt) when it can't find the
object you've named.

Your three fields, are they text fields, into which you have inserted the
letter "X"?  Are they True/False fields, that store a "0" and a "-1" (for
Access data), but can be made to display a checkbox, or ...?

How you total up the columns depends on what the columns hold ... you might
need to use "Count" instead of "Sum"!

Also, from your description, it sounds like the three fields are actually
mutually exclusive (i.e., a record can only ever be only one of the three).
If that's the case, then your table is designed more like a spreadsheet than
a relational database table.

If this is true, you could use a single field and store the status
(accepted, rejected, pending) in that field.

Regards

Jeff Boyce
Microsoft Office/Access MVP