I haven't asked a question here in a while so I hope I am not asking too much.
Currently, I am using MS Access 2007.
My problem is that I have a calculation in my form of which the variables are also recorded on a table, but I also need the calculated value to be recorded on the table. I know recording a calculated field is discouraged, but for my access, the each record will only have one value which will never change, so it won't cause any problems down the line.
As an example, lets say there are 4 fields on the table;
1. Total ABC
2. A
3. B
4. C
On the form, there are 4 fields same as the table, but A, B and C are directly recorded onto the corresponding table field, and Total ABC calculates the sum of A, B and C then records it to its corresponding table field.
If at all possible, can someone make a working example MS Access document since my understanding of how this is done is not up to par?
Currently, I am using MS Access 2007.
My problem is that I have a calculation in my form of which the variables are also recorded on a table, but I also need the calculated value to be recorded on the table. I know recording a calculated field is discouraged, but for my access, the each record will only have one value which will never change, so it won't cause any problems down the line.
As an example, lets say there are 4 fields on the table;
1. Total ABC
2. A
3. B
4. C
On the form, there are 4 fields same as the table, but A, B and C are directly recorded onto the corresponding table field, and Total ABC calculates the sum of A, B and C then records it to its corresponding table field.
If at all possible, can someone make a working example MS Access document since my understanding of how this is done is not up to par?