Hi,
I have a query (MonthlyInputQry) which calculates the total input into a production process by month (where month is a number 1-12) and there is a year (2013, 2014, etc). This query is based off a table (InputTbl) which records each individual order which goes through the process and then adds up the combined weight for all orders in the month.
I also have a table (MonthlyCostsTbl) where the costs per month of the process are displayed, and on this table there is a space for to input the monthly input as calcuated by the previous query (with the aim to find the cost p/kg each month)
At the moment, at the end of each month I have been looking at the value contained within the query for the applicable month (so March 2014 would be Month = 3; Year = 2014) and copying and pasting this value into the table.
Is there a way in which I could get this value in the table to automatically update, either in the form of a running total or at the end of the month? Either from the query itself or from the original table of inputs.
Thank you!
I have a query (MonthlyInputQry) which calculates the total input into a production process by month (where month is a number 1-12) and there is a year (2013, 2014, etc). This query is based off a table (InputTbl) which records each individual order which goes through the process and then adds up the combined weight for all orders in the month.
I also have a table (MonthlyCostsTbl) where the costs per month of the process are displayed, and on this table there is a space for to input the monthly input as calcuated by the previous query (with the aim to find the cost p/kg each month)
At the moment, at the end of each month I have been looking at the value contained within the query for the applicable month (so March 2014 would be Month = 3; Year = 2014) and copying and pasting this value into the table.
Is there a way in which I could get this value in the table to automatically update, either in the form of a running total or at the end of the month? Either from the query itself or from the original table of inputs.
Thank you!
