Adding & Subtracting Numbers(Fields) with Expression Builder

This has got to be simple but I don't see it. I have a simple query of a
table and I can see all the fields (defined as numbers in the table) in the
database. I simply want to add and subtract the fields to get a computed
value in the query. Currently the calculated column is always turns out
blank. (e.g.Expr1:
Alphy!Level-Alphy!Upright-Alphy!Chest-Alphy!Storeroom-Alphy!Kitchen or
simply an order amount equal to a desired level minus all on hand amounts in
the database) What is the exact syntax required for an computational
replacement in a query?

TIA, Stuart

On Mon, 18 Dec 2006 23:20:18 GMT, Stuart wrote:

This has got to be simple but I don't see it. I have a simple query of a
table and I can see all the fields (defined as numbers in the table) in the
database. I simply want to add and subtract the fields to get a computed
value in the query. Currently the calculated column is always turns out
blank. (e.g.Expr1:
Alphy!Level-Alphy!Upright-Alphy!Chest-Alphy!Storeroom-Alphy!Kitchen or
simply an order amount equal to a desired level minus all on hand amounts in
the database) What is the exact syntax required for an computational
replacement in a query?

TIA, Stuart

Use the dot, not the bang.
Alphy.Level

It's likely one of the fields is null.
Some value + Null = Null.
Use the Nz() function. Look it up in VBA help.

Expr1:Nz([Level],0) - Nz([Upright],0) - Nz([Chest],0) -
Nz([Storeroom],0) - Nz([Kitchen],0)

--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

Thanks Fred. That fixed it.
Stuart//
"fredg" wrote in message
. ..
On Mon, 18 Dec 2006 23:20:18 GMT, Stuart wrote:

This has got to be simple but I don't see it. I have a simple query of a
table and I can see all the fields (defined as numbers in the table) in
the
database. I simply want to add and subtract the fields to get a computed
value in the query. Currently the calculated column is always turns out
blank. (e.g.Expr1:
Alphy!Level-Alphy!Upright-Alphy!Chest-Alphy!Storeroom-Alphy!Kitchen or
simply an order amount equal to a desired level minus all on hand amounts
in
the database) What is the exact syntax required for an computational
replacement in a query?

TIA, Stuart

Use the dot, not the bang.
Alphy.Level

It's likely one of the fields is null.
Some value + Null = Null.
Use the Nz() function. Look it up in VBA help.

Expr1:Nz([Level],0) - Nz([Upright],0) - Nz([Chest],0) -
Nz([Storeroom],0) - Nz([Kitchen],0)

--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail