Query is blank if one subquery has no records

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?
 
J

Jerry Whittle

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

loop though records in a query? 5
Crosstab query totals 3
Removing duplicates when joining 2 queries together 1
Finding unique records in a query 3
Query keeps looking for Query1 field 3
Displaying two unrealead query results under one query?Possible? 2
Updatable query no longer updatable, and slow IN clause 1
How do you pass parameters between queries in Microso 2

Top