John - oops. When I tried this Union Query:

SELECT OrgID, FY, "WATSALE_RESIDENTIAL" AS Account, [WATSALE_RESIDENTIAL] AS
Value
FROM TFia_SD_WATER_ENTERPRISE
WHERE [WATSALE_RESIDENTIAL] IS NOT NULL
UNION ALL
SELECT OrgID, FY, "WATSALE_BUSINESS", [WATSALE_BUSINESS]
FROM TFia_SD_WATER_ENTERPRISE
WHERE [WATSALE_BUSINESS] IS NOT NULL

It get the message" SELECT statement includes a reserved word or (mispelled
or missing) argument name, or punctuation is incorrect.

Can you see what's wrong?


The table's name is TFia_SD_WATER_ENTERPRISE because the SD_* is the
original name of the Table from SCO, and the TFia is my table naming
convention code to keep track of the dozens of tables I've got. (I'm building
this DB not just for Special Districts, but for every other type of local
jurisdiction in the state as well. So - in additioni to the 16 tables for
Districts, I've got another 45 to 50 or so for other types of organizations.

Thanks

John D