I have created a query to add records into an existing table.
This table and query are linked by a Primary key
I have no problems adding the records and it is updating the table, however it is adding the records at the top of the table, see attached screen print.
I require these records to be added to the bottom of the table, for printing and validation reasons.
It doesn't matter what serial number or failure code added to the record, they are always saved in this location.