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

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.
 
J

John Spencer

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
..
 
A

accesshar

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
 

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

Null field in append query 4
Insert row, table to table - where append goes to correct record 2
Like validation problem in SQL append query 5
How to do an append query to a table from a recordset 2
How to write an append query on a recordset 1
Update and insert a Date into a field in sql - correctly 4
append SQL no records 8
Recordset - looping thru to append to another table 2

Top