append query - if column is null insert value

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

Guest

I am importing data and I want nulls to come in as default values, is there a way I can manipulate the SQL to do this or do I need to update my source tables (I would prefer to leave the source alone)?
 
Change it to a calculated field in the query.

NewFieldName:Nz([FieldName], ValueYouWant)

You will have to add quotes if the value is text instead of numeric.

--
Wayne Morgan
Microsoft Access MVP


lena said:
I am importing data and I want nulls to come in as default values, is
Click to expand...
there a way I can manipulate the SQL to do this or do I need to update my
source tables (I would prefer to leave the source alone)?
 
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

Appending null data and moving! 4
Problem with Null value elimintation criteria 1
Make one final list from four sources 1
Unmatched Append help 4
Append Query Issue 0
Append queries - Column Headers 2
Append query key violation 8
Joins on NULL Date values 3

Back
Top