Query giving unexpected results

[Aggie70]

Goal: Join 2 text files on field called ReportName and display the matches. 2 simple text files containing ReportName and FilePath, CreationDate and LastAccessDate. ReportName data type is text and set to 255 in length. I'm only getting 2 matching results. I can clearly see the data has many matches but my query only returns 2. I have no limiters set - so I'm reporting ALL results per the properties on the query.

Before I logged in here and to simply this even more, I cut out the ReportName field from both files and created 2 new text files (Notepad) with ReportName only. Used these 2 tables to run the same query and still get 2 results only.

Example that SHOULD be returned but isn't:
PDriveReportName=CDLIS Report
DLSReportName=CDLIS Report

 

[pbaldy]

Are you sure there aren't spaces in one or the other that would cause them to be seen as different?

 

[Aggie70]

Thanks for the reply. Yes sir I did. I went so far as adding Like "CDLIS*"and still no results. I can see the data in both tables.

These tables were exported from external programs. I've seen a tic mark get added to data upon export but I don't even see that here.

I'm missing something very simple here and its driving me batty!

Edit: did wild card on both sides of text....like "*CDLIS*" and still no match.

 

[pbaldy]

That would affect the criteria, but if you're joining on that field it could still be an issue. Can you post the db here?

 

[Aggie70]

I apologize for not getting back here timely. Ended up trimming the data field (left and right) and got matches.

 

[pbaldy]

Glad you got it sorted out.