Query is blank if one subquery has no records

  • Thread starter Thread starter RussCRM
  • Start date Start date
R

RussCRM

I have a query (CombinedQuery) that pulls values from two other
queries to use on a subform. If Query2 has no records, then Query1
comes up blank also. Any idea why this happens?
 
You have an Inner join between them. Therefore they both need matching
records or neither will show.

In query design view double click on the join line between the two until a
dialog box shows up. Try one of the other options and see what happens.
 
Back
Top