I surely don't know anything about access (accept for using it like a dummy-user. But this typical problem sounds like a formatting problem. If the criteria is a number, and numbers as text or formulas are imported you can get these kind of problems.
sometimes you'll have to think outside of the box. Why don't you export the data again from access to excel. You'll than have a total overview for all entries and can compare the formatting. Succes!