Query Not Returning a Record (1 Viewer)

[JGravesNBS]

I have a query Out of Work TT (query) that is not returning a record:

083-74-7222 Last 2 First 2

I attached a TestHelp.mdb database for your review

Member Info (table)
Last First MI SS#
Last 1 First 1 E 054645589
Last 2 First 2 083747222
Last 3 First 3 J 093843090
Last 4 First 4 J 126820943

Out of Work T (table)
SS# Last First Phone
054-64-5589 Last 1 First 1 (111) 111-1111
083-74-7222 Last 2 First 2 (222) 222-2222
093-84-3090 Last 3 First 3 (333) 333-3333
126-82-0943 Last 4 First 4 (444) 444-4444

Out of Work TT (query)
SELECT [Out of Work T].[SS#], [Out of Work T].Last, [Out of Work T].First
FROM [Out of Work T] INNER JOIN [member info] ON [Out of Work T].[SS#] = [member info].[SS#];

SS# Last First
054-64-5589 Last 1 First 1
093-84-3090 Last 3 First 3
126-82-0943 Last 4 First 4

Missing
083-74-7222 Last 2 First 2

 

[moke123]

try a left join

 

[jdraw]

Did you try Moke's suggestion?

Other recommendations:
-Don't have embedded spaces in table or field names.
-Don't use special characters in names (@#$%...etc.
Stick with alpha and numerics and "_" (underscore)

 

[JGravesNBS]

The query worked

Thanks for the recommendations, I follow those recommendations in own databases, however I inherited this database and it is what it is