We help IT Professionals succeed at work.
Get Started
Access - Join on Two Fields, With and Without Third Field in Output
I have two tables with 15 fields, of which 3 are Last Name, First Name, and ID.
I join Last Name from Table A, to Last Name form Table B, and the same for First Name. I also then Group By to get single row values.
When I join just on names, I get an output row count of 1900 (ID is not in the query).
When I join on the two fields, Last Name, First Name - but this time have ID in the output but not joined, I get an output row count of 2100.
What i am trying to understand is why does the count go up when ID is included in Design View, but is not being joined between Tables A and B.
Thank you.
I join Last Name from Table A, to Last Name form Table B, and the same for First Name. I also then Group By to get single row values.
When I join just on names, I get an output row count of 1900 (ID is not in the query).
When I join on the two fields, Last Name, First Name - but this time have ID in the output but not joined, I get an output row count of 2100.
What i am trying to understand is why does the count go up when ID is included in Design View, but is not being joined between Tables A and B.
Thank you.
Why Experts Exchange?
Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.
Jim Murphy
Programmer at Smart IT Solutions
When asked, what has been your best career decision?
Deciding to stick with EE.
Mohamed Asif
Technical Department Head
Being involved with EE helped me to grow personally and professionally.
Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question
Connect with Certified Experts to gain insight and support on specific technology challenges including:
- Troubleshooting
- Research
- Professional Opinions
Did You Know?
We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE