I have a database set up for a company where in one of the tables i have a set of orders where some are locked because they are completed. At the moment each sale by a customer is in a new row on the table.
I need to run a query to have a total for all of the customers totals. this needs 5to be a running total and everytime a new sale is completed the total has to be updated.
Will it be best to create a whole new table or run it through a query. any help would be appreciated.
Sorry if it is not explained very well but i am new to this.