Producing records from nothing

  • Thread starter Thread starter Jacques Latoison
  • Start date Start date
J

Jacques Latoison

I have a report that pulls from Query1.

Query1 pulls from 6 queries (A through F).

There are times when one of the A through F queries will produce no records
(which is correct), but this causes Query1 to produce no records since one
of the Queries it pulls from has no records. This in turn makes the report
who #Error.

How can I make a query show a record (View Totals is selected) when one or
more of the fields has no data.
I've tried changing the Join from Show all of one...etc, but I get errors
whenever I try that with more than one source to pull from.

Any help would be appreciated.
 
Look at the joins between A through to F. Double click on the join line and
you'll have 3 options. I'll guess you need the 2nd one.
 
Back
Top