I Have this Formula and it's not working, Access giving an error, appreciate any help.

SubClass1: Left(([AA]![BB2],5)=([CC]![DD2],[DD3]),"N")

AA - is a Table with All Data
BB2 - Column Header in AA with 8 digits numbers

CC - Table with Data
DD2 - Column Header in CC With 5 digit numbers
DD3 - Column Header in CC with 5 digit Numbers

Need to look in Table AA Column BB2 check the number from left 5 digits if match with Table CC Column DD2 then get the data in Column DD3 same row. if no match enter N


Thank you.