copy query field to table field sometimes diff value

[ano]

the newest record 16/01/2024 08:00:00 can get a new row if rate mn changes
delete 17/01/2024 00:00:00 to test that
the rate should be 50 because exchange rate not known yet
the topay need to copy to advance to be add/deduct next payment
looks like addnew goes well
but update add 900 ? in second row????
following ? the values are ok
using form.recordsetclone
after sql and and recordset had same issue

table abc give nick name
table advance give advance
table earn give earns copied from internet
table rates give the exchange rate from email
query tegoed give the result of earn*rate-sum advance
dt and md are selection fields
rt is adjusting advance
module tegoed create advance row when rate is added
filters sync the 5 subform on name and or date
create_earn set up new database
Input_Fx_Example input from saved internet the earn

[ano]

further testing:
1st records is ok
2nd record is -900
3rd record is -1300 4th record is -1300
but im only copy tegoed to advance as edit or addnew

solved dont use clone