Not getting all required fields

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am a novice who is pulling her hair out, please help me. I have a query
that asks for data from serveral tables, based on dates. My problem is that
if any one table has no information on a particular date I get no information
from the other tables on that date either.
 
You should decide which table is the main table, that you want all the
records to return from that table even if there is no match in the other
tables.
Chenge the link between the tables from inner join to left or right join.

Open the query in design view, double click on the line that connect the two
tables, you'll get a form where you can change the type of connection between
the two tables.
change it from inner to left/right join
 
Back
Top