Search results

Hi Good morning, i need to convert the following Excel formula into MS access. First one =IF($J2="","",IF($L2<>"",IF(OR($K2=$L2,$M2>=7),"EXPIRED","RETURNED"),IF($K2-TODAY()>=1,$K2-TODAY(),"EXPIRED"))) second one =IF(J2="","",IF(L2="","Open","Closed")) J2 refers Received Date L2 refers...