append query - if column is null insert value

L

lena

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)?
 
W

Wayne Morgan

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)?
 
Top