Added new field to query

  • Thread starter Charles G via AccessMonster.com
  • Start date
C

Charles G via AccessMonster.com

I've added a new field to my query, [Rolled Coin], and added this change to
my expression in my query in which I run a report.
Volume: Sum((((((((([Pennyrolls]+[Nickelrolls]+[Dimerolls]+[Quarterrolls]+
[Halverolls]+[Dollarrolls]+[Boxx50]+[Currency Volume]+[Rolled Coin]))))))))).

Now when I run my report my Volume field is empty?

I have two queries. One query has all the calculations while the second query
is built from the first in which I run my report.

I thought I could add [Rolled Coin] to my table, make a textbox in my form,
add it to my expression above and add the field to my 2nd query. Of course,
this didn't work.

-Charles-
 
G

George Nicholson

Does your table have any Null values? If any of the fields that make up your
Volume calculation are Null, Volume will be Null.
You should probably use the NZ function to coerce Null values to Zero.

Volume: Sum(nz([Pennyrolls],0) + nz([Nickelrolls],0) + (etc)....)

HTH,
 
C

Charles G via AccessMonster.com

Does your table have any Null values? If any of the fields that make up your
Volume calculation are Null, Volume will be Null.
You should probably use the NZ function to coerce Null values to Zero.
Click to expand...

Right on George! Thank you very much.
 
Top