Producing records from nothing

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

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.


.

Relevant Pages

  • Re: Subreports based on user input from queries
    ... I have 4 queries which are needed to generate this one report. ... these queries into reports it requeries Query1 over and over again asking ... Is there a way to get the subreports to reference the main report? ...
    (microsoft.public.access.reports)
  • Re: Asks for date multiple times...
    ... Doug Steele, Microsoft Access MVP ... But when I do the report ... from two different queries, both asking for dates. ...
    (microsoft.public.access.forms)
  • Re: Multiple queries using 1 report
    ... I am have several queries that are in the same ... format with different saved criteria. ... I can get the selected report to open but cannot get the Record Source ... Me.RecordSource = "Query1" ...
    (microsoft.public.access.reports)
  • Re: Producing records from nothing
    ... >I have a report that pulls from Query1. ... > since one of the Queries it pulls from has no records. ...
    (microsoft.public.access.queries)
  • Re: Avoiding each subreport asking for primary key
    ... Point your queries to a field on a form. ... Report 2 pulls all Red Gizmos, report 3 pulls all red whozits, ... Rather than put the criteria in the color column for each query, ...
    (microsoft.public.access.reports)