Hello,
In an append query with a Key field I find that the records seem to be automatically sorted on the Key field. They get inserted in between the records. I would like the new records to be appended to the bottom of the table. I have tried to look into the table sort orders but couldn't figure out how to do this. I would appreciate any help on how this can be done.
Thanks
In an append query with a Key field I find that the records seem to be automatically sorted on the Key field. They get inserted in between the records. I would like the new records to be appended to the bottom of the table. I have tried to look into the table sort orders but couldn't figure out how to do this. I would appreciate any help on how this can be done.
Thanks