Solved Query pulling more records than I want (1 Viewer)

[Maike]

Good Afternoon,

first off apologies for the noob question... it's been a long time since I've worked with access and clearly I'm rusty. Here is what I'm looking at :

Linked table (Excel sheet) "FPNA Data" (376 records)
Linked table (SQL server) "vwMaster" (11k records)

Both links have a common field called "Facility ID" and I have set the relationship to Link that field from FPNA to vwMaster and in the join type I chose "2: Include ALL records from FPNA Data and only those records from vwMAster where the joined fields are equal."

My goal is this: List all 376 records from the FPNA data tab and supplement information from the vwMaster for those 376 records. All 376 facility IDs match between the two tables.

Running a query that combines fields from both tables, returns the 11k records from vwMaster however.

What am I doing wrong?

 

[Isaac]

You probably want an inner join instead?

 

[Maike]

I was thinking left join, but when I looked at the SQL I realized that it left joined the wrong way... flipped them around and all is peachy now. Apologies and thank you!

 

[Isaac]

Sweet, glad you got it worked out!