How to I add two sums in access?

[Guest]

I have a stupid question and I'm not very familiar with access. But I linked
a excel spreadsheet to Access and I created a report using the wizard and I
have two fields, one add the total salary:
=Sum([Total Salary])
and the other add the total fringe:
=Sum([Total Fringe])

Now I want to add the two results. I have created a text box and the
expression:
=Sum([Total Salaries]+[Total Fringe])
But when I run the report is asking me to enter a parameter value (I don't
know what that is). Am I doing this correctly?

 

[Duane Hookom]

You aren't consistent [Total Salary] vs [Total Salaries]. Using the proper
field names should work as long as both values are non-null values.

 

[Guest]

Hi, Wendy.

You can only sum fields from the table, not controls on the form. Use the
Nz() function to convert a null value to zero. Try:

= Nz(Sum([Total Salary])) + Nz(Sum([Total Fringe]))

Sprinks