Hi All, please could you help me understand, i have this scenario and not sure whether i am approaching this correct.
I need to update the value in a control in a table by adding a value from another table to the existing value
can I do the addition in an update query form and to the same table or do i need to copy to a temporary table, do the addition and then copy back to the original table?
I need to update the value in a control in a table by adding a value from another table to the existing value
can I do the addition in an update query form and to the same table or do i need to copy to a temporary table, do the addition and then copy back to the original table?