New query using 2 other query's

[Roger]

Howard
What I am doing is making a report based on a query.
The query critiria for date is Between[Enter start Date]
and[Enter End Date] Which is what I need so the dates
can be keyed in and return the data between those dates,
My problem is the ballance is also just for the data
between the dates. Which I have the sum of in the report
footer now. I need the Total Ballance which is much
different than the sum of the dates ballance.
Hope I explained it right. Basically a check book with
capability of entering begin date and end date.
Thanks
Roger

-----Original Message-----
Couple of things:

If the query you're trying to build id going to be the
source for a Report, you don't need to worry about it.
You can total in any footer (category footer or Report
footer) of a Report so you'll just need your first query
with the detail.

If you need to have it in a query, what you want is a
Union Query which, alas, cannot be built in DesignView and
has to be written in SQL. Check the help files for Union
Queries but, in brief, you join the data from more than
one source (say, from two other queries) however all the
sources have to have all the same fields! The basic
format of a Union Query is:

SELECT [Table1].[Field1], [Table1].[Field2], [Table1].
[Field3]
FROM Table1

UNION SELECT [Table2].[Field1], [Table2].[Field2],
[Table2].[Field3];

Hope this helps!

Howard Brody

-----Original Message-----
I am trying to creat a new query based on 2 existing
queries. The wizard tell me I can do it, but when I try
it tells me it can't do it. New query must be table to
table or query to query. I have query to query, I've
tried query to query based on table, it won't work either.
What am I doing wrong, my book does not address this
problem.
What I am trying to accomplish is. Have a check book, with
income, expenses and ballance, by date entered criteria.
this works great, but in the report footer I would like
to have the Grand total of the account ballance, not the
ballance for the dates entered. Am I going about this
wrong?
I thought one query with all info by date, and the other
query where I could get the Grand Total of ballance.
thus the reason for new query based on 2 queries.
Am I going about this wrong
Thanks for any help
Roger
.

.