Query: Records Not Found

[cjh7111]

Hi all,

I'm new to Access so I'm a little lost. So I've created a query with the following SQL:

SELECT Table1.[Material Key], Table1.[Material Name], Table1.[Info]
FROM Table1 INNER JOIN search_MaterialKeys ON [Material Key] = search_MaterialKeys.[MaterialKeySearch];

So at the moment, users paste material numbers in the search_materialKeys table and the query is created with the necessary information. If the number they paste into the search_materialKeys table is not found in Table1 then the query doesnt return anything. I need the query to list all the entered values in the temptable in the query so that users know which of their inputs were not found. Is there any way to do this?

 

[plog]

Yes, you basically switch the tables and make it a LEFT JOIN query:

SELECT search_MaterialKeys.[MaterialKeySearch], Table1.[Material Name], Table1.[Info]
FROM search_MaterialKeys LEFT JOIN Table1 ON [Material Key] = search_MaterialKeys.[MaterialKeySearch];