R
Rich R.
I am querying the results of a UNION query that joined 2 sets of data
(expenses and revenue). I want to return all the rows from the UNION query,
but I only want dollar amounts for those rows that contain 'expenses' (I
later want to do the same thing to deliver 'renenue' rows). The whole point
of this exercise is to produce a report that delivers expense amounts and
revenue amounts side by side. The number of expense rows in the UNION result
does NOT EQUAL the number of revenue rows.
The initial simple query written is:
SELECT qrySandySS_union.Appr_Sequence AS [Section], qrySandySS_union.[Agency
Long Name], qrySandySS_union.[Line Item Long Name],
qrySandySS_union.Appr_Unit_Long_Name, qrySandySS_union.Object_Category_Desc
AS [Expense Type], qrySandySS_union.type, qrySandySS_union.[CY Act Final]
FROM qrySandySS_union
WHERE (((qrySandySS_union.type)="E"))
ORDER BY qrySandySS_union.Appr_Sequence;
This WHERE clause, of course delivers only expense rows. Any suggestions on
how to deliver ALL rows, even though the [CT ACT] value of the non-expense
rows will be null?
(expenses and revenue). I want to return all the rows from the UNION query,
but I only want dollar amounts for those rows that contain 'expenses' (I
later want to do the same thing to deliver 'renenue' rows). The whole point
of this exercise is to produce a report that delivers expense amounts and
revenue amounts side by side. The number of expense rows in the UNION result
does NOT EQUAL the number of revenue rows.
The initial simple query written is:
SELECT qrySandySS_union.Appr_Sequence AS [Section], qrySandySS_union.[Agency
Long Name], qrySandySS_union.[Line Item Long Name],
qrySandySS_union.Appr_Unit_Long_Name, qrySandySS_union.Object_Category_Desc
AS [Expense Type], qrySandySS_union.type, qrySandySS_union.[CY Act Final]
FROM qrySandySS_union
WHERE (((qrySandySS_union.type)="E"))
ORDER BY qrySandySS_union.Appr_Sequence;
This WHERE clause, of course delivers only expense rows. Any suggestions on
how to deliver ALL rows, even though the [CT ACT] value of the non-expense
rows will be null?