Quote Originally Posted by fatta77 View Post
From MS Access you can run the following query instead of creating a program:
UPDATE TableName SET ColumnName=0 WHERE ColumnName IS NULL
Thanks. Just added that quesry to the database and it worked perfectly.

Quote Originally Posted by codecarnage View Post
I was wondering why this wasn't done in the first place.
Becuase I never knew it could be done that way....?

Quote Originally Posted by psybuck2002us View Post
There are times when NULL database values represent a field better than just adding a zero or empty string.
Not in this case. The default value should be 0 (in case of entries before the date Customs instituted the Environment Fee or when the calculation called for it to be 0)

Quote Originally Posted by CGPGroup View Post
I was wondering why a program was needed for this. set the default value for the column to "0", run the update query above and all is well. should not take more than 2 mins.
As above that's what I did. 0 was the default when I created the column.

I can now use this query for future new columns and/or future database tables.