How to duplicate access records

[Patrick1900]

Am in need of help with access. I need to program a button which will duplicate all records in a given table containing a value <0 in a specific field
and then it leaves the field value in the original record to be 0.
Example;
I have a table with fields


ID StudentName Grade Fee AmountPaid Balance Overpayment Term
1 name1 2 $100 $150 0 $50 Term 1


I want if any records has a value in overpayment >0 then it should be duplicated while clearing the value in the original record of overpayment field and then changes the term field to term two in the dublicated redord?


Is this possible?

[Welshgasman]

So despite the fact I overpaid in Term1 by $50, you want to show it as an overpayment of $50 in Term2.?

Normally you just sum charges, and payments and display the difference?, so if I make another overpayment of $50 in Term2 this time, then I will be in credit for $100 and can skip payng for Term3 ?

[Micron]

If I may embellish that advice just a bit: you do calculations and show results in form or report fields. Generally speaking, one shout not store calculations in tables as you are showing (Balance). Copying records is usually ill advised as well, even if they are from properly designed table fields.