if month(date)<month(Mdate) AND lnAcno=acno AND year(Mdate)=year(date) lnBalance=0 endif if lnAcno=acno AND year(Mdate)>year(date) and lnBalance=0 and month(date)<month(Mdate)+12 lnBalance=lnMbalance endif if lnAcno=acno and MONTH(date)=MONTH(Mdate) and day(date)<=10 and year(Mdate)=year(date) lnBalance=lnBbalance endif *** so manyHow I can change my code to speed it up.If you allow I can send the code to you via email.