Change blank field value to 0

[El Jagang]

I'm building a relatively basic inventory database as a placeholder until a sophisticated program is rolled out in a few months to track inventory and production. I did a data dump from an Excel sheet to get all the product info; however, I created a quantity field, which wasn't on the spreadsheet.

We've done some counting and put in those quantities, however I'd like the items for which we haven't done the count yet to show a value of zero in the Qty field. I could do this by hand, but since there are around 2,300 records, I'm sure there's a quicker way of doing that.

I've created and run a query that returns all the records in which the Qty field "Is Null", however now I'm not sure how to proceed with the automatic change. I looked at the "Find and Replace" feature, but that didn't seem to work.

I've read a bit on the Nz function, however it seems that I've jumped a little too far ahead in my attemps to learn, because when I look at the syntax: Nz ( variant, [ value_if_null ] ), I have no idea what the variant is supposed to be, and the "A variable that is a variant datatype." description is no help at all.

Any help would be greatly appreciated!

 

[plog]

I've created and run a query that returns all the records in which the Qty field "Is Null"

Your 90% there with that. What you need to do now is:

1. Backup your database (always rule #1 in anything you do).
2. In Design view of your query, click on the Update option in the ribbon.
3. In the query, under your Qty field, in the Update To: row, put a 0.
4. In the ribbon, click on the Run option and it will make your changes.

 

[El Jagang]

Thanks, much obliged!