469,647 Members | 1,697 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,647 developers. It's quick & easy.

New joined table added to query

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
1 1911
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.

Similar topics

2 posts views Thread by Mike Leahy | last post: by
1 post views Thread by Ersin Gençtürk | last post: by
1 post views Thread by Ike | last post: by
5 posts views Thread by zMisc | last post: by
4 posts views Thread by Frank List | last post: by
reply views Thread by gheharukoh7 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.