Select Query not displaying data from both tables

[DXZ08]

Hi, I've run into a problem with my Select query.
I've imported two excel files into Access and saved them as Access tables. I've created two initial queries to filter both tables for the results I wanted. Now I'm trying to join the data from the two queries into a new one and I'm baffled why it doesn't work. Both queries contain the same SubjectID formatted as text that I'm using as join. One of the tables contains multiple rows of data per SubjectID and I want to see all of those multiple rows in the query output, thus the join is set up to show all records from this table and only those from the second table that match. The second table contains only one row of data per SubjectID.
I'm only trying to add one column of data from the second table to the first one and when I run the query, it displays only data from the first table - the column name shows up from the second table, but not the data. I cannot figure out why this is. I've made thousands of Select queries before and I can't figure out why this is happening. Any pointers?

 

[Phildaburn]

In the 2 tables, are the SubjectID fields formatted and sized identically?

Is your relationship backwards? Are you linking the many-table to the one-table instead of the one-to-many?

 

[DXZ08]

Both SubjectID fields are formatted as Text:
Field Size: 255
Required: No
Allow Zero Length: Yes
Indexed: Yes (Duplicates OK)
Unicode Compression: No
IME Mode: No Control
IME Sentence Mode: None

The join is set correctly, however, I haven't set any Table Relationships for this database, which wasn't a problem before either.

 

[Phildaburn]

In one of the tables are there one or more spaces after the SubjectID?

 

[DXZ08]

Phildaburn, you hit the nail on the head! There was an invisible space after the SubjectID in one of the tables. Once I deleted it, it worked fine!

Thank you! Thank you! Thank you!

 

[Phildaburn]

Congrats! My pleasure to help...
Phil...