Total in Query

  • Thread starter Thread starter ladybug via AccessMonster.com
  • Start date Start date
L

ladybug via AccessMonster.com

I am creating a query that has three fields in it, Rejects, Denials, and
Other. Each entry may have data in all 3 fields or only one.
I created an expression to add all the 3 fields together, Expression:
[intRejects]+[intDenials]+[intOther]
As you can see in the Total below, it will only add if all 3 fields have data.


Program Date SumOfintRejects SumOfintDenials SumOfintOther
Total
AA 04/14/2006 830 160
30 539
AA 04/15/2006 47 10

How can I total all three fields regardless if all 3 fields have data or not?
 
That worked perfectly! Thank you so much.

Duane said:
Use an expression like:
Nz([intRejects],0) + Nz([intDenials],0)+Nz([intOther],0)
I am creating a query that has three fields in it, Rejects, Denials, and
Other. Each entry may have data in all 3 fields or only one.
Click to expand...
[quoted text clipped - 11 lines]
How can I total all three fields regardless if all 3 fields have data or
not?
Click to expand...
Click to expand...
 
Back
Top