Okay, I have read multiple posts on this type of update and have not found (or understood) any results that help me.
My database is tracking billed accounts, their respective details, special APRs, payments, etc...
I this form and subform (See Figure 1):
Now, I am trying to reduce the account balance by the amount of the payment. My first step was to create a selective query identifying payments from today forward to avoid accounting for payments made in the past again which produces the following results (See Figure 2).
So far so good. This gives me only the payments I have scheduled not including any payments made in the past. Now comes time to update my Biller table by the results from my PaymentHistory query (See Figure 3). I create an Update query like this (See Figure 4):
Now this works except for one problem: It adds the payment to all of my Billers, not just the one in which the true payment applies. So, it subtracts $40.00 from Citibank's balance and $40.00 from other account balances. Thinking I know why this happened, I add a column to my Update query that attempts to match the BillerName in the query to the BillerName in my Biller table so it only updates the payments and dates that match a particular record like (See Figure 5):
I then try to run the Update query and I receive the "Type Mismatch In Expression" error and the query has no effect on any data. I take a look at my query and Access has removed the "=" sign from my criteria column (See Figure 6).
I added the SQL view for those of you that it makes sense to and the "=" is still there.
Does anybody understand what is going on?