Update Query to Change Values From One Table To Another

[Ange Kappas]

Hi,
I have two tables with a number of fields in each table.
In one table called ACCOUNTS CHARGED the yes/no field called CHARGED is
always by default "yes" everytime a record is entered in it.
I want it every time to update the table called RESPEL ALL CHARGES (when
running an Update Query) the identical field CHARGED by looking at the RESNO
field in the table ACCOUNTS CHARGED to be the same as the RESNO field in the
table RESPEL ALL CHARGES.

Thanks