Re: Producing records from nothing
- From: "JohnFol" <OutlookExpress@xxxxxxxxxxxxxxxx>
- Date: Wed, 11 May 2005 12:48:47 GMT
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.
"Jacques Latoison" <Jacques Latoison at hotmail dot com> wrote in message
news:%23GYKUaXVFHA.1384@xxxxxxxxxxxxxxxxxxxxxxx
>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.
>
.
- References:
- Producing records from nothing
- From: Jacques Latoison
- Producing records from nothing
- Prev by Date: Re: How to make a "self-added" field in form or query?
- Next by Date: Re: Need query field assigning line number for each found record
- Previous by thread: Producing records from nothing
- Next by thread: Re: Get the query to show records
- Index(es):
Relevant Pages
|
