Respected Madam, in excel built in sum function is easy to handle. But in MS Access, there is no such function in form level. Besides I do not know how to build a SUM function or module. For example, in a form level programme, I want total of two fields with result in the third field and tried with the following code: Dim x as integer X = "Select ( field 1 + field 2) from table 1 where ID=1" but receiving error message. This was written in the third field's Got Focus event. Shall be grateful if anyone can help with correct way to execute the variables, codes etc.
![Visual Calculations in Power BI - DAX Made Easy! [Full Course]](http://i.ytimg.com/vi/JITM2iW2uLQ/mqdefault.jpg)
Images in focus would help.
Respected Madam, in excel built in sum function is easy to handle. But in MS Access, there is no such function in form level. Besides I do not know how to build a SUM function or module. For example, in a form level programme, I want total of two fields with result in the third field and tried with the following code:
Dim x as integer
X = "Select ( field 1 + field 2) from table 1 where ID=1" but receiving error message. This was written in the third field's Got Focus event. Shall be grateful if anyone can help with correct way to execute the variables, codes etc.