Combine Similar Data From Three Queries

[Kerberos]

Hello,



I have three queries from the same table. Each of the three quereis have the same column headings.

What I wish to do is combine the data from the three queries into one report, but clearly distinguish within the reports, or somehow delineate, the data from each query.

So, for example, one query is Cash, one Income, the other Expense. These three queries would be combined into one report with a clear heading and summation of each set of data.

Is this possible, please?

Thank You

[JoeM]

Take a look at Subreports: http://office.microsoft.com/en-us/ac...010209281.aspx

[Kerberos]

Thank You, Joe . . .