>I am trying to "append" a new record into a table...however, I would like it to be inserted into the middle of the table instead of the end. Is this at all possible? TIA :)

Just out of curiousity, why? It shouldn't matter a whole lot. If you are doing somehting where the records need to show in the correct order, add a numeric "order" specifing whats first, second, ect.field and index on something like group + str(order)