Calculta

[Louie]

I am ne to this and I have a access book and was trying different things and
Supposedly in a table where the Data Type is “Number†if the cell is blank it
should read as “0†not null.

When I create a query referencing this number it cannot calculate any cell
that is blank. It should calculate against a 0 quantity.


Example:

OH Qty On Order Qty Supply
5 10 15

blank 10 showing
Blank but (should be 10)

What do I need todo to get this to work.. ?

Than you..

 

[Douglas J. Steele]

Do you need it to display a zero, or do you actually need a zero for
calculation purposes?

If the former, just set a format. Something like 0;-0;0;0 should do it.

If the latter, change your query to use the Nz function. Assuming the field
is named OH Qty, use something like Nz([OH Qty], 0) in your query.

 

[Louie]

Thank you Douglas I will give this a try..

Do you need it to display a zero, or do you actually need a zero for
calculation purposes?

If the former, just set a format. Something like 0;-0;0;0 should do it.

If the latter, change your query to use the Nz function. Assuming the field
is named OH Qty, use something like Nz([OH Qty], 0) in your query.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

I am ne to this and I have a access book and was trying different things
and
Supposedly in a table where the Data Type is "Number" if the cell is blank
it
should read as "0" not null.

When I create a query referencing this number it cannot calculate any cell
that is blank. It should calculate against a 0 quantity.


Example:

OH Qty On Order Qty Supply
5 10 15

blank 10 showing
Blank but (should be 10)

What do I need todo to get this to work.. ?

Than you..