Does anyone know how I can use VBA to take one value from one table and add to it a value from another table and then put that total into one field of the original table. I've been fighting with this for a couple of days so now i am looking for some help.