Integer in a access query

[MrDeej]

Hello guys!

Is there any way to dim a calculated field in a query as integer or long or something?

I want to achieve that zero's come in the field if it is blank like it does in a table. This is because of further calulating on the field

[hjozinovic]

You can use Nz() function for your calculated field.
Look it up in you access help!