Home > IT Answers > Database > Access Calculations
Greenenergy
5 pts.
 Access Calculations
Microsoft Access
Recently made database table in acces. Then made a form from the fields in this table. Data entered into from appears in database table. Added calculations to form, calculated results appear in access form but not in related fields in access database table.

Software/Hardware used:
Access 2007
ASKED: May 8, 2010  6:42 PM
UPDATED: May 11, 2010  5:43 AM
RELATED QUESTIONS
Answer Wiki:
Check the "Control Source" for the field. Make sure it points to the database.
Last Wiki Answer Submitted:  May 10, 2010  4:47 pm  by  DPaxton   165 pts.
All Answer Wiki Contributors:  DPaxton   165 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

Please provide more details.

How did you add these calculations ? Are the results being displayed in a text field ?

How do you want to store the results in the table ? Do you have an additional table column for the calculation results ?

carlosdl
 63,580 pts.
 

You can’t have formula and column name simultaneously as the data source for a control.

msi77
 1,610 pts.