Pink Floyd, Thank you for your prompt response. However, I'm still not sure how do I perform the calculation in the form. I'm new to access and have been given this project. I can not change the original numbers in the table so I guess I can't do the append query. i would like to do it using the form if thats possible. Again, in the table I have fields called A, B, C, D, E etc. I need to manipulate the number of As, Bs, Cs ..... in a different ways. For e.g: Table: Field Name Number A 7 B 25 C 15 D 99 E 105 The field names are not always constant, sometimes I may not have one of them in the table. Now, I need to calculate the As by dividing it by 2 , so the calulated field must have A/2 multiply B by 2, multiply C by 5 etc. Thanks again for your help.