Trying to create an update query need help

[Buddha1]

I am trying to create an update query that will update Tbl B info with a field from Tbl A. Example:
Tbl A contains the following fields: Site Batch# Date
Tbl B contains the following fields: Site Date Batch Acct#
I want to update the batch field in Tbl B with the batch number in Table A. I want the field to update only those fields whose date and site match in both tables. Can someone help me with this?

 

[BNPMike]

Join A to B on Date and Site. Then put [TableA.Batch] as the update criterion for TableB.Batch. The QBE Screen will build the SQL for you.