Nz() - keeping the number format correct

[ulteriormotif]

Hiya.

I'm using a lot of Nz([myfield],0) at the moment to get around tables that may not have matching records, and it is working fine on that level.

The problem is Nz([myfield],0) causes the values in that column of the query to left align, and apparently no longer be defined as numbers, ie, I can't right click in the query and select number formatting - nor can I successfully apply number formatting to those fields in my reports.

There must be something simple I'm missing here - how do I get my numbers to stay numbers? Any help appreciated.

 

[ulteriormotif]

Problem solved - wrap it in an Int() and i get my number format back.