I'm taking over a database from a colleague who had retired.
In this database, there is a table (Receiving Records) and a Append Query. User has to run the Append Query few times daily and this query will prompt user to enter 2 criterions (date and time of the last record from table (Receiving Records)). The query will then extract records from MRP system and append them (with Receiving date and Receiving time > than the 2 criterions) into table (Receiving Records).
I'm now starting to automate this manual entry process with programming as below.
The LastRecordedDate is correct. But the LastRecorded Time returns Null value, instead of 190700. Can someone help to check what had caused this error
Below the last few records from the table (Receiving Records) and field data type:
Appreciate your help.
Best Regards.