Query problem


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


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Query Problem 2
Query problem 0
query problem 2
Query Problem 4
Query Problem 3
query problem 2
Query Problem 9
query problem 4