Re: Query not displaying all requested records
- From: "Duane Hookom" <DuaneAtNoSpanHookomDotNet>
- Date: Thu, 5 Oct 2006 16:42:55 -0500
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.
--
Duane Hookom
MS Access MVP
"Richard" <Richard@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:EDC72057-1328-45E1-94C8-EE42B451669C@xxxxxxxxxxxxxxxx
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.
.
- Prev by Date: Concatinated String with grouped result?
- Next by Date: Re: Concatinated String with grouped result?
- Previous by thread: Concatinated String with grouped result?
- Next by thread: Parameter Query based on field in current form
- Index(es):
Relevant Pages
|
