I have a table with about 50 fields. If the value in the first field is = '99' I would like to loop thru each of the remaining fields and if the field data type is numeric and the current value is null, I would like the value changed to 0. Is there a straight forward way using vba to do this?
The table name is dbo_stafil00
The first field name is whs, and that is the field we need to test for being equal to '99'
All of the other fields need to be tested to determine if they are numeric and if so, test for null and if that is also true changed to 0