Hi,
I have 2 tables and 2 queries from which I want to combine summary fields into one report
I have table costs, and table payment Schedules. These contain all of the costs allocated to a specific job for which I have built a query and report which shows all of the summary costs of each cost type for one of the many jobs we have. The second is a table of all of the payments either scheduled or paid for one job and I have built a report and query to show the amount to be paid or actually paid. What I want is to combine the Summary of costs and the summary of payments actually paid to see the instant profitability of any job. So I want to set up the query, I assume a cross tab query, to interrogate both tables and make a calculated field (2 actually) to show the profit on a job and the % profit on teh turnover.
Is that possible? I can't seem to figure it out.
Thanks