Hello,
Can anyone help me with this please (I'm moderately competent with Access but not up to speed with VBA or Macros):
I have a table full of transaction records to date. There are many thousands of transactions.
Now I want to forward plan a budget for the next year for a particular transaction type. I thought that the best way to do this would be to:
- Create a Make Table Query and select the latest year of transactions of the type I need and so have a table I can mess around with without disturbing my working table.
- Run an Update Query to raise the date of each transaction by one year and to inflate the transaction cost by today's rate of inflation.
- Run an Append Query to paste these back into my original Transaction Table.
- I can then create a Report showing what my future budget might look like and as the current date moves into the future, I can replace my estimates with real data.
I noticed that the new table I created keeps the ID (Primary Key - which in my case is just an integer) from the Transaction Table.
So, my questions are:
- If I Append my modified records back into my Transaction Table, will it paste them with new ID's or will it overwrite the transactions with same Ids andtherefore ruin my historical Transactions?
- In your opinion, is this an acceptable solution or is there a better way of working?
Thanks