Losing information when running a query

[NewAccessDude]

Good morning,

I have a query that compares a column in Table A with a column in Table B,
and when the information in these two columns match it pulls information from
a second column in Table B and displays that.

Currently if the columns do not match up I lose the data completely. I want
my query (or a new query) to pull that information as well so I can see why
it did not match.

For example, I have 50 items in Table A and when I compare them to Table B
48 items match so my query pulls those 48 items. But now I have lost those 2
items where it did not match.

Any ideas?

 

[Sylvain Lafontaine]

Use a Left Join instead of an Inner Join.

 

[Michel Walsh]

If you want to see all records from tableA (at least once), rather than only
those with a match, in the query designer, right click on the link
indicating the join, in the graphical part, and chose option 2.

Chose option 3 if you want to see all records from tableB.

If you want to see all records from both tables, you will have to create a
more complex query.

Vanderghast, Access MVP

 

[NewAccessDude]

I'm still feeling my wait thru Access, could you be a little more specific

thanks

 

[Sylvain Lafontaine]

Essentially the same thing as suggested by Michel in the other post. If
you're using the Query Designer, when you will choose the option 2, a Left
Join will be created.

If you're not using the Graphical Query Designer, then replace the words
INNER JOIN with LEFT JOIN if you can see the text of the query. If not,
come back but a little more explanation on how you are creating and running
your queries.