By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
464,271 Members | 1,428 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 464,271 IT Pros & Developers. It's quick & easy.

New joined table added to query

P: n/a
I have a query that uses two joined tables. The query contains data.
I would like to pull in a data drom another table but when I add that
table to the query design and make the join,the existing data is not
shown in the query in datasheet view. I have realised that this is
because the joined fields in the existing data were not populated to
link to the newly added table. I can understand why data was not
pulled in from the new table but why is the existing data not
shown?????

Help please!
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply

P: n/a
mh***@insightconsult.co.uk (Michael) wrote in
news:b9**************************@posting.google.c om:
I have a query that uses two joined tables. The query
contains data. I would like to pull in a data drom another
table but when I add that table to the query design and make
the join,the existing data is not shown in the query in
datasheet view. I have realised that this is because the
joined fields in the existing data were not populated to link
to the newly added table. I can understand why data was not
pulled in from the new table but why is the existing data not
shown?????

Help please!

Michael, when you added the new table to the query grid, you joined
a field in the new table to a field in one of the existing tables.
By default, Access creates what is called an inner join. This
limits the rows to those where the data is identical. You need to
change that to a left join. Here's how.

Open the query in design mode. double-click on the line between
your old table and the new. select option 2 or option 3, depending
on which table is the old table. You have to read the fine print to
decide. Save the query and view the data.

Good luck.
--
Bob Quintal

PA is y I've altered my email address.
Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.