I am designing a database to store and calculate products + prices in a video shop. I have created a query to calculate amound due etc, but i want to create a table for recording all transactions made. In the query you can to do this using the make table option, but when you update it again it deletes the previous data. HELP ME PLEASE!

Also explain as simply as possibly.

Thanks

I d be interseted to know why you think you need to store the calculation results, not simply produce them when needed.

Otherwise, you may either want to use an append query or an update query depending on how you store transaction results (all transactions records chronologically: append query / or update old records: update query).

Have a look to Access Help on these topics.

Alex