Converting Null Value to $0.00

[jfrink2]

Hi All,

I have a table that has fields that captures dollar amounts. I have these fields set to a default value of "0".

The tables are updated via a query that imports a csv file. Once the import process has finished, my table has blank values in some of the fields that capture dollar amounts.

If a field populated by the csv file is left blank, I would like for the field to show $0.00.

How would you recommend handling this?

 

[pbaldy]

You can use the Nz() function to replace Null with 0.

 

[jfrink2]

You can use the Nz() function to replace Null with 0.

Would that be after the file has been imported to the tables? Or would you have the query make this adjustment to the file during the import process?

 

[pbaldy]

You can use it at any point. The most logical sounds like during the import, so you never have to worry about the Nulls again.

 

[gemma-the-husky]

it depends what a null represents

null exists to enable you to distingusih between zero, and an "empty value" that you havent got around to verifying yet.

the distinction may be important in some cases

 

[jfrink2]

it depends what a null represents

null exists to enable you to distingusih between zero, and an "empty value" that you havent got around to verifying yet.

the distinction may be important in some cases

Null in this case represents an empty value.