Adding values using visual basic

[clark]

I am trying to write simple code in visual basic for a module to add the contents of two fields in my table and update the result in another field in the table (macro and sql stuff too lengthy). I am novice, what is the syntax?

Table name = Main
Table field names = Expense1 and Expense2, TotalExpense

main table (syntax?). total expense = expense1 (syntax?) + expense 2 (syntax?). Also do i have to define variables even though contained in access?

thank you

Thank you

 

[Rich]

Given that you should not store calculated fields in this way, use a query or calculated controls on forms or reports to display the calculation.