Search results

Actually do want to insert a new record (ie contactID - 753 has a record in dues table for every yr they have paid dues.) for each contactID that has a 2007 entry. No I dont think I know how to do this with a procedure. Tips?

I have table Dues For each record in tblDues where duesyear =2007 i want to add a record where duesyear = 2008 and state dues amount = 120.00

tblDues I want to add Year = 2008 and StateDues ='120' for all contact records who have a record in table Dues for 2007 SELECT tblDues.ContactID, tblDues.DuesYear, tblDues.StateDues FROM tblContacts LEFT JOIN tblDues ON tblContacts.ContactID = tblDues.ContactID WHERE...