Prev: Opening Report Closes Database
Next: Firstname plus Middlename??
From: Jen on 3 Jun 2010 13:17
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.
From: KARL DEWEY on 3 Jun 2010 13:55
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.
 | 
Pages: 1
Prev: Opening Report Closes Database
Next: Firstname plus Middlename??