Query not displaying all requested records

[Guest]

Hello everyone,

I am creating a query which is a combination of two tables (contains fields
from both Table A and Table B). Though I now don't specify any criteria in
the query design view, the query will display form me only the records where
there is an entry in any one of the fields in Table B. So if a particular
record doesn't have any entries in any of the fields from Table B, that
record won't show in my query... one can only assume that if I likewise had a
record with no entries in any of the fields in Table A, but had entries in
Table B, I would as well not see that record come up in my query.

Why?

If I look at the SQL for the query, the query is joining the tables via a
Union Join. Perhaps a different join for Table A and Table B would resolve
this problem?

Any ideas?

Thanks, Richard.

 

[Guest]

Sorry, Inner Join, actually...

 

[Guest]

Anyone want to give it a try, see if you get the same results?

Simple Query Wizard, choose say, two fields from one table, then select a
second table, and choose two fields from the second table, two fields from
which you know you'll have some records without any entries in these two
fields, then view the query checking if the records with no entries in the
two fields in question are showing at all in this query (again, no criteria
stipulated in this query, all records should be showing, no?).

 

[Duane Hookom]

This is expected behavior. Did you try other joins? Double-click the join
line to change the property to select all the records from Table A.

 

[Guest]

))

Just that quickly/easily, I believe you've resolved my problem. I'll write
back tomorrow if still problematic, otherwise I won't, need to do more
testing tomorrow, but looks good, looks real good... Thanks Duane!