G Guest Dec 8, 2003 #1 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)?
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 Dec 8, 2003 #2 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)?
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)?
