If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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. |
Thread Tools | |
Display Modes | |
|
|