How to insert values on blanl fields

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi. I've got several records that have no data on some columns. I want insert
zeros on those records witch has no values, but on the records that have
values I don't want to touch on those.

I try to make a queries to insert but it asks me for a critaria, but the
criteria is all blank fields.

Can you help me?

Regards,
Marco
 
What you want is an Update query. You don't need any criteria unless you
don't what to include all records. The way to do this is to use the Nz
function to change Null values to zero for all your numeric fields. Here is
an example:

Field: SOME_NUMERIC_STUFF
Table: tblUselessInfo
Update To: Nz(SOME_NUMERIC_STUFF, 0)

This will not affect fields with data. It will only change Nulls to 0.
 
Back
Top