Use a left join from contracts to services.
In design view click on the connecting line, double click, and select option
to show all contracts.
--
Build a little, test a little.


"Jen" wrote:

Background first:

I have a database for tracking contracts. Some contracts are
straightforward and only cover one service but the bulk cover multiple
services that will be performed at different times. I have the following
tables:

Customer
Contract
ContractLine
Services

Under each Contract, if it has multiple services I connect the Contract and
the ContractLine tables.

Now to my issue....I need a report that will display all Contracts whether
it contains multiple services or not. I have been able to run a report where
it will display all the contracts with multiple services and the dates the
service was performed but this report will not show single service contracts.
I have also run a report where it will show all contracts (multiple service
and single) but it will not display each service performed under
mulit-service contracts.

I am stuck.