Excel formulas in Acess

[mondoman1]

Hi,

After several years away from MS Access I now need to get back into it. I created a reliability report many years ago using MS Excel. My plan was to develop MS Access to automate the report but I didn't get to it. New job new need. I'm after ideas on recreating the MS Excel formula below in MS Access. Also is it best to do this type of calculation on a form or when generating a report.

=IF(AND(K416>V416,U416>V416),"RA",IF(AND(K416>V416,T416>V416,
AC416<>"CL"),"AL",IF(AND(Q416>V416,T416>V416,AC416<>"CL"),
"AL",IF(AND(Q416>V416,N416>V416,AC416<>"CL"),"AL",
IF(AND(K416>V416,U416<V416,AC416<>"CL"),"AL","CL")))))

Thks for your help

mondoman1

 

[Ed2020]

I'd put it in a query, replacing the cell references with field references and using the IIf() function. The query can then be used as the recordsource for a form or report, whichever is your preference.

Ed Metcalfe.

Please do not feed the trolls.....

 

[mondoman1]

Ed2020,

Thks for yr reply. I will give it a go.

mondoman1