Missing records

[Assamita]

Hi everyone. I have a question that for you is probably very simple, but I'm just getting into Access and I don't know how can I do this.

I have a table that looks something like this:

SAP user	Complete name
USER1	First1 Last1
USER2	First2 Last2
USER3	First3 Last3
USER4	First4 Last4
USER5	First5 Last5

And then I have a linked excel with a large number of sales orders and the SAP user who created them.

I want to have a query that converts that SAP user into the complete name, so I created a query with the two tables and linked the field SAP user. The problem is that the table is not the complete list of users, there might be others. So what happens is that the query populates only the registers that have SAP users that match the table, but leaves the rest out.



Is there any way to create a query with all the registers of the linked excel, and then have a column with the Complete name if the user exists in the table, or leave it blank if it doesn't?

I hope I explained myself properly.

Thank you

[isladogs]

Use an outer join query where the query uses all excel records and the other table where records exist.
The query join will show an arrow pointing away from the Excel file

[Assamita]

Thank you! that was very helpful! (and as I expected, very simple).