View Single Post
  #1  
Old June 3rd, 2010, 06:17 PM posted to microsoft.public.access.reports
Jen
external usenet poster
 
Posts: 544
Default Report only displaying some info

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.