Adding from two tables in VBA

10 pts.
Tags:
tables
VBA
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.

Software/Hardware used:
Access 2003 and VBA 2003

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • TomLiotta
    There are a couple reasonable possibilities that depend on the two tables. Please show how you SELECT from each of them and show an example UPDATE statement. The UPDATE can simply assume a variable value. From those, either suggestions can be made or appropriate questions can be asked to get to suggestions. -- Tom
    125,585 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: