Sum column comes up blank

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

Guest

I am trying to add a field to my query which totals three other fields. My
column keeps coming up blank, even though there are values in the three
fields it is suppose to total.
My Exprs is:
Expr1: [PRICE]+[Adj]+[Prog_Adj]

This query is based on another union query, which in turn is based on 3
tables that are excel links. The union query works fine, however any attempt
I make at adding a column to total 3 other values in either this union query,
or another query based on it, does not.

I have created a 'dummy' query based on another simple query, with just a
few fields and did a total column and it worked fine. I'm quite new to
access and I wanted to be sure I was doing it right before I posted here.
The dummy query produces and answer in the column with 3 fields added.

My real query has over 20,000 rows, and 20 columns. I wouldn't think the
size would matter.

Other suggestions I can check?
 
Two issues:
a) Any nulls will generate a Null outcome.
b) Access frequently misunderstands the data type of calculated fields.

To solve both issues, try:
CCur(Nz([Price],0)) + CCur(Nz([Adj],0)) + CCur(Nz([Prog-Acj],0))

More info:
Calculated fields misinterpreted
at:
http://allenbrowne.com/ser-45.html
 
Try this. Expr1: =nz([PRICE])+ nz([Adj])+ nz([Prog_Adj])
Sometimes the "non-zero" addition solves null problems.
 
Back
Top