INSERT SQL to append recs frm another Table, NULL DATE append 30/1

  • Thread starter Thread starter accesshar
  • Start date Start date
A

accesshar

When records are read into a record set, and used to be inserted via SQL to
another table, if the Date field is blank, the Date is appended as
30/12/1899. This corrupts the data for the user, as I need the blank date to
be maintained in the table being appended, how can a blank date be appended
as a blank date to another table using the Insert SQL statement.
 
Suggest you post the SQL text of the Insert query and the data type of the
source date field.

(Possibly unneeded instructions follow)
Open the query
Select View:Sql from the Menu
Select all the text
Copy it
Paste it into the message

--
John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County
..
 
It's OK, Sorted the problem by changing the Data Type of the variables from
DATE to Variant. Null Dates are appended correctly now as null, and dates
that are not null are appended correctly as dates
 
Back
Top