Unanswered: Insert null value in column-type is date/time & format is ShortDate ,in Access 2002
I am trying to insert Null value in column(ShipDate) in my table.That column(ShipDate)'s type id date/time and format is short date.
I am using "" to insert Null in that column(ShipDate) but it shows warning that customer can't append all the records in the append query.
Customer set 1 field(s) to Null due to a type conersion failure,and it didn't add 0 record(s) to the table due to key violation, 0 record(s) due to lock violations, and 0 record(s) due to validation rule violations.
Do you want to run the action query anyway?
But still if I click on Yes than it will simply execute the query and insert null value in table.
And if I click on No than it cancel the execution of query.
its caused just because i set type as date/time and put format as short date in that column(ShipDate) in my table.