Hi guys
i am having problems with a query that i will be using of a chart in access 2013.
i have2 query's called income by year and spend per year
Income per year
SELECT [Account Transactions].[Entry Date], [Account Transactions].[Total Payment]FROM [Account Transactions] INNER JOIN Categories ON [Account Transactions].Category = Categories.ID
WHERE ((([Account Transactions]![Money In])=-1))
ORDER BY [Account Transactions].[Entry Date];
spend per year
SELECT [Account Transactions].[Entry Date], [Account Transactions].[Total Payment]
FROM [Account Transactions] INNER JOIN Categories ON [Account Transactions].Category = Categories.ID
WHERE ((([Account Transactions]![Money out])=-1))
ORDER BY [Account Transactions].[Entry Date];
each of these query's work and i am able to make a bar graph from each query that represent the figures correctly.
what i can't seam to do is to have these query's create 1 graph that shows both the income and the spend by year, for example income would be green, spend would be red.
if anyone could give me some pointers i would really appreciator it.
Steve