I imported a spreadsheet into tbl_A.
I imported a text file into tbl_B.
tbl_A that has corresponding information on tbl_B. I verified this by manually searching tbl_B using a few of the entries from tbl_A -- and was able to locate the corresponding rows.
Next I created a select query joining the two tables on 'userid' -- but no records are returned.
The 'userid' field in both tables is formatted as Text. The only difference is the size of the field. But even when I make the field sizes the same -- I don't get any results......
Here is the query SQL:
SELECT tbl_A.UserID, tbl_B.UserID, tbl_B.LastName, tbl_B.FirstName
FROM tbl_A INNER JOIN tbl_B ON tbl_A.UserID = tbl_B.UserID;
Any ideas why I'm not getting expected results?