Re: Adding & Subtracting Numbers(Fields) with Expression Builder
- From: "Stuart" <sarooney@xxxxxxxxxxxxxx>
- Date: Tue, 19 Dec 2006 15:53:15 GMT
Thanks Fred. That fixed it.
Stuart//
"fredg" <fgutkind@xxxxxxxxxxxxxxx> wrote in message
news:1ge282cex2p9a$.1ook65ch5gopx$.dlg@xxxxxxxxxxxxx
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
.
- References:
- Prev by Date: Re: Running Total
- Next by Date: RE: Running Total
- Previous by thread: Re: Adding & Subtracting Numbers(Fields) with Expression Builder
- Next by thread: Re: Cleaning up database
- Index(es):
Relevant Pages
|
