Adding textbox sum to a table

[PRodgers4284]

Im having a problem adding two textboxes that contain calculation value to a table. The calculations are inside two textboxes called "Total" and "Action". The form i am working on is series of questions and i need to calculate an overall percentage based on the user inputs at the end of the form and then add the results to a table. Can anyone provide some help?

My database is below:

 

[speakers_86]

Well, first, people usually zip there db's before uploading them. But to answer your question, calculation fields should not be stored in tables. Use a query to compute a calculation. Just google "microsoft access queries" and I'm sure youll find pretty easily how to create a calcution field in query.

Unless you have unique needs and really need this done, then you would have to use an append query to
1. compute the total
2. append that value to the appropriate record in the table.

Hope that helps!

 

[PRodgers4284]

Well, first, people usually zip there db's before uploading them. But to answer your question, calculation fields should not be stored in tables. Use a query to compute a calculation. Just google "microsoft access queries" and I'm sure youll find pretty easily how to create a calcution field in query.

Unless you have unique needs and really need this done, then you would have to use an append query to
1. compute the total
2. append that value to the appropriate record in the table.

Hope that helps!

Hey thanks for that, i totally forgot about the zipping the file, really appreciate your help