Hi there
i'm trying to create a calibration database for work. I have a field which show the date of last calibration, called "date of last calibration". for the freq of calibration i am using a field with the option of 1,2,3 which equals 6 , 12 or 24 month. I am trying to add a field in a query to show the date when the next calibration is due. some thing like Datedue:iff([freq]=1,dateadd("m",6,[date of last calibration],iif([freq]=2,dateadd("m",12,[date of last calibration],iif[freq]=3,dateadd("m",24",[date of last calibration])))
I just can't get it to work. Can any one help and show the correct formula i need to put in.