Report Display -- Headers as Rows

[MoeIndustries]

Hello, I have a query with the table below. When I run a report it naturally lists the results also as per this table. How can I get it to show the results as per the next table down? Thanks!!

Fund	Income	Expenses
Permanent	10	-7
Unrestricted	15	-9
Endowment	9	-4

	Permanent	Unrestricted	Endowment
Income	10	15	9
Expenses	-7	-9	-4

[June7]

That would involve a UNION query.

SELECT Income AS Data, "Income" AS DataType, Fund FROM tablename
UN ION SELECT Expenses, "Expenses", Fund FROM tablename;

Now use that query as the source for a CROSSTAB query.

[MoeIndustries]

Hello, thank you very much for the help - could you possibly clarify how the UNION query would need to be written? I'm still very new to UNION queries. I think I get the concept, just the execution I'm not sure of. THANKS!!

[June7]

There is no wizard or designer for UNION query, must type into SQL View of query builder.

The first SELECT line sets the field names and datatypes. There is a limit of 50 SELECT lines.

What exactly do you not understand about the syntax shown in the example?