archive and dmax new table

[deekras]

i want to archive my transaction table. (i can do that). and then empty out the table.

i need to update the transaction table with just the balances for each account. ( i can figure out the balances, as well).

my problem is that i need to use transaction numbers for the record for each account's balance. this number should start where the archive leaves off. i need the system to figure out what the number is and then give each balance record a transcation number.

can i use dmax in an append query? how?

thanks