query sometimes returns no data

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

Guest

I have a Query to generate a Report that is a form letter. I have a table
with a Name that is pulled by the query into the Report. I have another
table with names and the company they are associated with. I have this table
so that if the Name has a Company the it will be added to the Report. The
query pulls the company name that is associated with the name into the
report. Here's my problem. If the Name in the first table is not in the
Name/Company table the entire report is blank. I would like the Name to
appear in the report even if it is not in the Name/Company table
 
Look at the Join Properties in your query in the Query Builder. My quess is
1 is clicked ("Only Include rows where the joined fields from both tables are
equal.")
Change it to either 2 or 3 to make it so the Name is always included, but
the company info will only be included where there is a match.
 
Back
Top