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.