Display query data based on another query

[Adnan]

I have seen such a query but can’t build one, tried to do it myself but I’m
missing something. I have a table tblEmployees and would want to create a
query that when I paste their badge numbers to populate the rest of their
information (such as name, address etc…) pretty much what VLOOKUP does on
excel.

Here’s what I did, I created a table tblInput with one column BadgeNr with
data type as Text, then created a query qryResults, I added tblInput and
tblEmployees, I linked BadgeNr with BadgeNr and I am showing no results. Now
when I enter the badge number in this query (tblInput.BadgeNr field), I want
all the rest of the employee information pupulated (from tblEmployees).

What am I missing here?

Any help, tip or info is much appreciated,
Adnan

 

[Golfinray]

You have to build a query with all the information, badge numbers, employee
name, and all other information. Then when you need to know , say, one
employee you can either use a form or go into the query, type the employee
name or badge number in the query criteria and it will then give you the
information. Also, your link has to be something common the both tables. If
badge number is in both tables and eqch employee only has one badge number,
then it should link. Look at the lonk line, right click on it to highlight
it, and you should get a list of link types. You may have to use type 2 or 3
to get the two tables to link properly.