Problem with a query in Access 2007

  • Thread starter Thread starter Lilian
  • Start date Start date
L

Lilian

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