Losing information when running a query

  • Thread starter Thread starter NewAccessDude
  • Start date Start date
N

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?
 
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
 
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.
 
Back
Top