Added new field to query

[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-

 

[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,

 

[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.

Right on George! Thank you very much.