C
Cameron Sutherland
I am usuming you are using an Update query...
Instead of using the Criteria line use the 'Update To'
line with the Nz function. Nz will replace any Null with a
value of your choosing. For example, if you have a field
called 'Field1' put this in the Update To parameter.
Nz([Field1],"CamIsCool") and run the query. Every Null
value will be replaced with CamIsCool (or whatever you
want). You can run one query with this for all 5 of your
fields at the same time if you like.
-Cameron Sutherland
Instead of using the Criteria line use the 'Update To'
line with the Nz function. Nz will replace any Null with a
value of your choosing. For example, if you have a field
called 'Field1' put this in the Update To parameter.
Nz([Field1],"CamIsCool") and run the query. Every Null
value will be replaced with CamIsCool (or whatever you
want). You can run one query with this for all 5 of your
fields at the same time if you like.
-Cameron Sutherland