Default Values on an excisting table

[Gootz11]

Hello All,
I have a table that gets imported daily into my database which has 3 different quantity fields. (qty1, qty2, qty3) most of the time my qty2 and qty3 fields are blank which prevents me from getting a total qty when i run a query that adds the three. I have the default value set at zero on the table but for some reason i can't get the blank fields to be replaced by zeros. any ideas?
Thanks in advance
JG

 

[dcx693]

A default value only gets placed into a field when you are creating a record. Since you have pre-existing data, then default value will have no effect. You want to update the blank values to 0, and for that you need an update query.

An update query is basically a regular query taken a step further. In a select query, you ask Access to show you records meeting a certain criteria. When you run an update query, you tell Access to take the records that meet a certain criteria and change a part of those records.

Look at the Access help system for "update query". If you need more help, post here again.