using modules to delete and append data

G

geek

i'm currently doing a fixed asset db, extracting the data from the SQL
server. as the depreciation for the fixed assets changes every month, i would
like to store the previous months of the fixed assets in a table. every
month, the user would press the update button on the form to update the
current month's depreciation data. however, i do not want duplicate data for
the current month should the user press the update button twice.

how do i get the modules to overwrite the current month's data without
deleting the data for the previous month?
 
Top