drblackard
ISP
I have created a form with members name (firstname, middlename, and lastname), membership dues amount, membership dues type, paid date, and paid membership dues for(year)....now I would like to update the membership dues amount annually without having to do all of them one by one, maybe a batch update or something...however there are several different charges, not all of them are the same. Is there someway to autoupdate each year? I would like for it to update the paid amount to update amount and membership dues for(year) to update to the next year if possible...I just don't have a clue on the code for this in the query...thanks