Sum of multiple numbers from query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I've got 3 fields that the user will put the numbers in I want to get a total
of all 3 fields.
field names:
ReExp
AvoidNumb
AutoArousal

total field: TotalPSS-SR
need help how do I make the query work?
Kim
 
Add an additional field to your query:
[TotalPSS-SR] = [ReExp] + [AvoidNumb] + [AutoArousal]
 
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

Access Dcount (multiple criteria) 3
How to subtract a number from a Mergefield? 0
Sum of field 1
Totaling An Aggregate Expression On A Report 4
totals for multiple fields 1
Access Field won't show as currency in the form, shows just a number (but works fine in the query) 1
Using SUM in summry Query 1
sum of calculated fields in header of report 1

Back
Top