Creating A Monthy Report Based On Several Querys

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have two querys "Wages Query" & "Expenses Query" which displays the
following values

Wages Query Expenses Query

Month Amount Month
Amount
8 £12,000 8
£22,000
9 £20,000 9
£27,000

I want to create a Monthly Report where i can select the Month value from a
form and a report is generated showing the specified months data eg amount of
wages and amount of expenses. Can anyone help me please
 
StuJol said:
I have two querys "Wages Query" & "Expenses Query" which displays the
following values

Wages Query Expenses Query

Month Amount Month Amount
8 £12,000 8 £22,000
9 £20,000 9 £27,000
Click to expand...
 
Create a union query based on your two queries:
SELECT Month, "wages" as Category, Amount
FROM qWages
UNION ALL
SELECT Month, "Expenses", Amount
FROM qExpenses;

Make your report based on this union query.
 
Thanks for info.

Im still not sure how to create a union query, please could you explain how
to build this in simple terms. Many Thanks. What part of the query do you
type union in?
 
You must enter sql similar to my earlier reply in the SQL view of the query.
If your query and fields names are different, then you must change them.

There is no "gui" design view of a union query.
 
Back
Top