Query result - Default value

[prabhu]

Hello,

When there is no data in the query result, How to give a default value like ZERO

Thanks,

Prabhu

 

[DCrake]

Wrap Nz([YourNumericField],0) around the field

 

[prabhu]

Thanks David,

But do i need to enter in VB module? I am new to access and i manage access with Query only. Is it possible to get it with query.

I tried entering this in Query field and but i didnt get the result.

 

[dz2k7]

How about this?
Put in a query
Result: iif([something] is not Null,[something],0)

 

[John Big Booty]

How about this?
Put in a query
Result: iif([something] is not Null,[something],0)

That is essentially the NZ() function, as previously suggested by DCrake, recreated using an Iif statement.

 

[prabhu]

Thank you John,

It worked for me.

 

[John Big Booty]

Glad you got it working