Hi,
I have a database that I use for reporting, however I would like to see the total quantity and total sales broken down by locations in one query which I would also then use in reports too. I have never used a union query, however I believe this is they way that I should go? I can't seem to get started on a union query, please can you look at my mock up database and maybe fix my union query for me please so I could copy it in the future?
I thought the following might work for me but it doesn't and as I don't have the union query knowledge yet then I cannot see where I have gone wrong.
Many thanks,
Malcolm
I have a database that I use for reporting, however I would like to see the total quantity and total sales broken down by locations in one query which I would also then use in reports too. I have never used a union query, however I believe this is they way that I should go? I can't seem to get started on a union query, please can you look at my mock up database and maybe fix my union query for me please so I could copy it in the future?
I thought the following might work for me but it doesn't and as I don't have the union query knowledge yet then I cannot see where I have gone wrong.
Code:
SELECT
Query1.Product,
Query1.1,
Query1.2
FROM Query1
UNION SELECT
Query2.Product,
Query2.1,
Query2.2
FROM Query2;
Many thanks,
Malcolm