Problem with a query in Access 2007

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Lilian - 19 May 2008 18:07 GMT

Hello experts in Access!
I'v got some problem with a query. In this query there are several connected
tables.
When I run a query I get empty lists. For example there is some info in
table 1 and table 2 but there is anything fylld in table 3. When I make a
query for table 1 and table 2 I get a answer with fylld list but when add
table 3 to this query automatically answer will be empty list.
Can somebody help me!
Best regards,
Lilian

Reply to this Message

KARL DEWEY - 19 May 2008 18:26 GMT

Sounds like you are using an INNER join and need a LEFT join.
In the design view double click on the line connecting your tables. Select
the option that will display the most records - example - display your master
table and only those of slave that match.
So figure out which table is to be the left most (has the most of the
records of the field you are joining on). An alternate is to use a union
query for a complete list of the field you are using to join and use it as
the left table.

Signature

KARL DEWEY
Build a little - Test a little

> Hello experts in Access!
> I'v got some problem with a query. In this query there are several connected
[quoted text clipped - 6 lines]
> Best regards,
> Lilian

Reply to this Message