Insert Value of 0

[Guest]

Would like to insert an expression to a query showing if quantity equals
blank insert 0. Thanks for the help.

 

[Ken Snell [MVP]]

Define "blank" --- is that an empty string? a null value? something else?

Look up IIf function in the Help files. It's commonly used for this type of
substitution.

 

[PC Datasheet]

Assuming by blank you mean Null, use this:
MyExpression:NZ([NameOfQuantityField],0)

MyExpression will equal Quantity when Quantity has a value and will equal 0
when Quantity is Null.

 

[Guest]

The formula being used is Calc IG: NZ([InwardsGoods]![StockCount],0). This
seems to work; however, the quantities become left justified. Is there away
to right justify them.

Query is against Linked tables.

I also tried using "IIF" but without any luck.

Thanks again!

Assuming by blank you mean Null, use this:
MyExpression:NZ([NameOfQuantityField],0)

MyExpression will equal Quantity when Quantity has a value and will equal 0
when Quantity is Null.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
(e-mail address removed)
www.pcdatasheet.com

Would like to insert an expression to a query showing if quantity equals
blank insert 0. Thanks for the help.

 

[PC Datasheet]

Try Calc IG: CLng(NZ([InwardsGoods]![StockCount],0))

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
(e-mail address removed)
www.pcdatasheet.com

The formula being used is Calc IG: NZ([InwardsGoods]![StockCount],0). This
seems to work; however, the quantities become left justified. Is there away
to right justify them.

Query is against Linked tables.

I also tried using "IIF" but without any luck.

Thanks again!

Assuming by blank you mean Null, use this:
MyExpression:NZ([NameOfQuantityField],0)

MyExpression will equal Quantity when Quantity has a value and will equal 0
when Quantity is Null.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
(e-mail address removed)
www.pcdatasheet.com

Would like to insert an expression to a query showing if quantity equals
blank insert 0. Thanks for the help.