Sounds like you need to make a report that has two subreports in it, each
subreport pointing to a different query.
You can try and join the two queries together and essentially make a one to
many relationship between the monthly records and the year records based on
a monthly record's year. This would essentially append that year's
information to each month's record but it would duplicate the yearly
information for as many months you have displayed.
You could slip that query into a single report easily though and just put
fields showing only the monthly portion of the query in the detail and then
group in the report on year and show the yearly information as a sum in the
footer.
Either way, use a report. You're into data display, not retrieval at this
point and that's what reports are for.
Casey
George Schneider said:
I have two queries. One fileds sales and total gaLLONS for the moth the
other one for the year. I'm trying to combinine the queries so I can
display the toals on a month and ytd date basis for a customer. When I try
it by numbers get distorted but the numbers are correct in the repective
individual queries.
