Update query not updating

[coyote]

As a part of an Inventory/Accounting system I have a table called tblAccounts with fields AccountID, AccountName and CurrentBalance.
The accounts are
AccountID AccountName CurrentBalance
1 Accounts Receivable 10,000.00
2 Cash at hand

I also have a table called InvoicePayment with fields PayID, PayDate, AccountID, AccountAdd,AmountPaid.
I have created 2 update queries. The first query is supposed to reduce the amount in AccountReceivable. The second query is supposed to add that amount to Cash at hand.

The problem is when i run the queries the first query reduces the amount but the second query does not add it to the account.
What am i doing wrong.

 

[Galaxiom]

Post the SQL of your queries.

 

[coyote]

As a part of an Inventory/Accounting system I have a table called tblAccounts with fields AccountID, AccountName and CurrentBalance.
The accounts are
AccountID AccountName CurrentBalance
1 Accounts Receivable 10,000.00
2 Cash at hand

I also have a table called InvoicePayment with fields PayID, PayDate, AccountID, AccountAdd,AmountPaid.
I have created 2 update queries. The first query is supposed to reduce the amount in AccountReceivable. The second query is supposed to add that amount to Cash at hand.

The problem is when i run the queries the first query reduces the amount but the second query does not add it to the account.
What am i doing wrong.

Well i have cracked it since i was updating records in the same table and the relationship was using the AccountID in both queries, i changed the relationship to AccountAdd in the second query and it works. Thanks