Thanks for the prompt response Rabbie.
I did try that as well, I created a query in which there are 2 columns, Field1 and Field2 which import the values from the table/form. In the third field, i entered: Total=[Field1]+[Field2].
On running this query, the Total is displayed correctly, but...