Hello,
Based on the information that you included in your
message, it sounds as if a "Union" query may work for you.
The general concept is as follows: You will use a union
query to combine the base data from your first 4
queries. Then, you will sum your union query in a
additional query.
Union queries are explained in Access's help files and on
Microsoft's website. When you create your union query,
don't forget that all your field names in our base
queries must match, therefore you may need to use aliases
in your base queries.
Good luck!
Jimmy
-----Original Message-----
I have five queries currently (let's call them query1 -
query5) which do a YTD sum from a table based on certain
criteria. Now I want to sum those five queries for the
Total YTD. I thought I could just create a new query
(TotalYTD) and add the existing 5 through the expression
builder but I can't seem to get it to work?
