Ive got a problem concerning union queries. I have a financial statement report based upon a union query which combines data from 4 tables. Its quite complicated, with a lot of calculations and parameters, but the basic structure is as follows:
SELECT [Date], [Income], "" As Expenditure...