Query help

[pm]

I've got a database that pulls the daily bank and store register amounts. I
query the bank activity without matching register amounts, then have a field
where I revise the amount in the register due to a deposit corretiion notice.
My question is, when i run my matching query - if the amount on the register
table is revised, then I want to match the revised amt with the bank versus
the original register amount. I know this can be done with an IF stmt - but
I don't know how to put this into Acess. Thanks for any suggestions.

 

[Arvin Meyer [MVP]]

In a database, you would use an Update query. Join the key value from each
table, then update the register amount with the bank amount (or visa versa).

 

[pm]

Hi Arvin,

Not quite sure this is what I want to do. I tried I want to have the
ability to see both the register amount and the revised register amount. In
matching the two amounts (register to Bank) if the revised amount is >0 than
I want the revised amount to match with the bank amt.
I tried doing this by using an update query and putting 'revised amount' as
my updated field, and got all blanks.....