I have created an append query to transfer some data from one table to another. This works fine but For some unknown reason it is not picking up all of the data. It is leaving out one row of data. The query picks up data that has been ticked off as complete but when i go to move them across, by...