IN the attached excel file columns J, K, and L are calculated, so far you all have helped me with column J and now I am struggling to finish the FRT Met or Overdue column, the excel formula is this =IF(OR(LEFT(M5,2)="CN",LEF
rdue")) and what I have come up with so far in access is this :
FRT Met or Overdue:
")) the problem may be parenthesis related but I can't seem to decipher it maybe I have been looking too long.
Lastly I will need to write something in my access query for when (column "K" which is FRT Met or Overdue) scores "overdue" I would like the month only from column I which is due_cmpln_date to populate.