Combine Results of 3 queries on a Report

[GPnew]

Hi,

I have three cross tab queries (each one based on separate tables)each which gives me an amount by month and region. One query gives me sales data , one expenses and one overheads

I need to put together a report grouped by region ie it takes the data for the region by month from each of the three queries so I get a total result by region by month.

I'm not sure where to start. Can this be done. What recordset would I use for the report. Or Do I need to restructure my queries ?

Thanks

 

[DougP]

This should work but maybe not too quickly
Create a 4th table
change your three queries and make them "append" queries
so they append to the new 4th table.
base report on 4th table.

DougP, MCP