Access Append Query to Force Record to Bottom of Table
Posted on 2016-11-14
I need to append a trailer record to a table that I've populated in Access. I need to force a specific row of data to the bottom of the table. I will be appending data to the table and this data needs to go to the bottom. The row I'm trying to append has three values from another table with totals from three columns.
When I currently go to append the record, the record becomes the second record of the table, there is already a header record that I've appended first. Then I have data under the header record and I need to end with this trailer record. The table I'm appending to is simply a formatting table, meaning I use this table to export as a fixed width text file- I don't do any further analysis with it.
Anyone have any suggestions on how I can do this?