Hi all,
Not sure if this is possible or if it is I will be able to get my head around it but here goes.
I have a form that has three text box fields each of these are number fields in the table the first 2 are to collect a value and the third adds the values from the first 2 and outputs the results in the text box.
The Control Source o the third txt box is this
=[field1]+[field2]
This works fine as it is but I am trying to pull this information into a query/report and this is what I need help with.
What I would like to do is pull a report that will list all of the department names that have been entered into the database and the total amount of spenditure next to each department.
The problem is that when the form calulates the numbers from fields1 and 2 it doesn't store this number. Is there a way that I can calulate the details from fields1 and 2 on the form, store this value in the same table for later extraction.
The only other way I could do it is not to have the form do the calculation, I then input the total manually, the report would then add up the totals for each department and display it next to the name but this is not the ideal solution.
Can anyone help? Thanks in advance
Not sure if this is possible or if it is I will be able to get my head around it but here goes.
I have a form that has three text box fields each of these are number fields in the table the first 2 are to collect a value and the third adds the values from the first 2 and outputs the results in the text box.
The Control Source o the third txt box is this
=[field1]+[field2]
This works fine as it is but I am trying to pull this information into a query/report and this is what I need help with.
What I would like to do is pull a report that will list all of the department names that have been entered into the database and the total amount of spenditure next to each department.
The problem is that when the form calulates the numbers from fields1 and 2 it doesn't store this number. Is there a way that I can calulate the details from fields1 and 2 on the form, store this value in the same table for later extraction.
The only other way I could do it is not to have the form do the calculation, I then input the total manually, the report would then add up the totals for each department and display it next to the name but this is not the ideal solution.
Can anyone help? Thanks in advance
