Figured it out. Have to learn to read more posts. Sometimes the answer is not
in the header but answered within a post that may be unrelated.

This group is terrific. Thank you all
--
CowichanDave


"cowichandave" wrote:

Doing a query on our accounting database for which am using 4 tables.

Client, Product, Detail, Serial number

Client is linked to Product by ClientID #
Product is linked to Detail by Invoice # (both keyed)
I have a date filter and this portion of the query works fine

I have tried different ways to link the serial table but the final query
only displays those results that have serial numbers. Not every invoice has a
serial number. I cannot modify the accounting program tables. So instead os
showing me 2000 records which is correct but adding the serial table limits
the query to 35 records. I need the 2000 records to include serial number
data. What am I missing?

I have tried linking the Detail table: linecode with the Serial table:linecode
--
CowichanDave