I am appending records from one table to another
And I am getting error that records are not appended because of validation rule error.
In table tblMasterRep Date filed is date/time filed type
In table for this field there is no option for allow Null value or not.
In table tblArchivedMaster Date filed is date/time type and could have null value.
Here is my query:
INSERT INTO tblMasterRep ( [DATE] )
I tried with : IIf(IsNull([DATE]),”Null”,[DATE])