I have a text field named txtA that has the equationi have another text field with this equationCode:=DateDiff("n",[Date_Fault_Lodged],[Resolution_Date_And_Time])
I would like to firstly change this to VBA code however i donot have the first clue of how to do this. also i would like to show the result in four decimal place and percentageCode:=(1-([txtA]/525000))*100