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.
 
You must log in or register to reply here.

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

Increment field by 1 on insert Query 2
Seriously, I need ideas. Fields not transferring from table to table 3
counting Null fields 3
Concatenate Text Fields to Date Field 5
Need null values for several fields in db 1
Query to count records in a table 2
quandary on selecting certian records 4
Use Insert Into to insert multiple records 9

Back
Top