MS Access DLookUp malfunction. : Good day everyone,

I have a very weird problem occurring in MS Access which I can't seem to figure out. The summary is: I have a table from Sharepoint that is connected to my MS Access db and a Person table in my Ms Access db. I pull the information row by row from the Sharepoint table and add it to Person Table. However, before adding the new data I must check if that specific Person already exists in my table. I check for 'Lastname', 'Firstname' and 'Date created' using DLookup function. Here where everything goes side ways. DLookup returns me a NULL for almost half of the record that already exist in Person Table. After playing a lot with the condition in DLookup statement my conclusion is that there is a problem with the 'Date created' parameter, yet I have tried using "#" and CDate and even Format, nothing works. 

Please help!

P.S: I have tried DCount, same thing happens. DCount returns 0 yet I know for a fact the record is there. 