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. |
#2
|
|||
|
|||
Report only displaying some info
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. |
Thread Tools | |
Display Modes | |
|
|