I am building a database for users of our computer systems. Each system has multiple users with different account access levels. I would like to be able to build a query that will ask the person who is doing the query to enter in identifying information. For example I have the following tables

Table for PC1
| UserName | Last Name | First Name | Access Level |
|:——– | :——– | :——— |:———— |
|User 1 | Smith | John | User |
|User 2 | Jones | Paul | User |
|User 3 | Adams | Micheal | User |
|User 4 | Edwards | James | Admin |

Table for PC2
| UserName | Last Name | First Name | Access Level |
|:——– | :——– | :——— |:———— |
|User 1 | Smith | John | User |
|User 2 | Edwards | James | Admin |
|User 3 | Edwards | James | User |
|User 4 | Jones | Paul | User |
|User 5 | Reid | George | User |
|User 6 | Markle | April | Manager |
|User 7 | Brown | Stephen | User |

Table for PC3
| UserName | Last Name | First Name | Access Level |
|:——– | :——– | :——— |:———— |
| User 1 | Smith | John | User |
| User 2 | Adams | Micheal | User |
| User 3 | Brown | Stephen | User |
| User 4 | Markle | April | Manager |
| User 5 | Edwards | James | Admin |

So, I’d like to be able to query

Last name: Edwards

First name: James

And have the query give me all lines where those two values are meet and add the name of the PC in the front of the results. Like this.

If this has to be done by using a query, report or VBA. Any of these options would be acceptable. I was thinking I might have to do this by using a macro but if it is possible using the built in functions of Access, I think it would be easier. I just am not familiar enough with Access to know where to begin. I have tried the Query Wizard but it only looks for duplicates in a single table. I was also thinking that I could have all of the tables populated into a hidden table and then have the query perform the duplicate search on the combined table. Any insight would be appreciated on this matter.