I'm working on a database of consultants, their contracts and amendments to those contracts. I have 3 queries that calculate values for conditional data. For instance, I have qryEndDate, which produces the contract's original end date unless the contract has been amended in which case it displays the max end date from the amendments corresponding to the contract.
I have 2 queries that count the number of amendments or payments for a particular contract.
Then there's the main contract table.
I tried making a query to hold all of the data that I'd like to go into a contracts report but because it comes from so many places, it gave me an error message about having too many joins.
How can I create the query?