Report only displaying some info

  • Thread starter Thread starter Jen
  • Start date Start date
J

Jen

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.
 
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.
 
Back
Top