Query giving unexpected results

Aggie70

New member
Local time
Today, 16:29
Joined
Sep 3, 2014
Messages
4
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

 
Last edited:
Are you sure there aren't spaces in one or the other that would cause them to be seen as different?
 
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.
 
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?
 
I apologize for not getting back here timely. Ended up trimming the data field (left and right) and got matches.
 
Glad you got it sorted out.
 

Users who are viewing this thread

Back
Top Bottom