i create update query to update fieldname DateOfTraining to 1/1/1999 but display error in query Group_A 30/12/1899 where error
i attach simple database
The same was my immediate response, but you can actually update a query, which then writes the values in the table. Therefore I deleted my response, but apparently not fast enough because OP had seen it.
The problem is that there are some minutes value in the "DateOfTraining" field.
Therefore the update query doesn't update because it has the criteria "IIf([DateOfTraining] Is Null .." and it isn't Null because of the minutes value.
The problem is that there are some minutes value in the "DateOfTraining" field.
Therefore the update query doesn't update because it has the criteria "IIf([DateOfTraining] Is Null .." and it isn't Null because of the minutes value.