colmtourque
Registered User.
- Local time
- Today, 18:14
- Joined
- Sep 26, 2002
- Messages
- 83
I was working on this problem as a query with Pat Hartman and she said to do a report that does what I want instead.
http://www.access-programmers.co.uk/forums/showthread.php?s=&postid=122934#post122934
I have done as she suggested with a report and subreports but my problem is now that if I have a report that has totals via the two queries. But I would like to be able to add the values from the two months.
To restate the problem as it relates to reports.
I have a main report run off of a table that has ID Number and name. (Grouped on ID Number).
Then off of that I have two sub reports by ID Number with values by Date By Month.
I would like to add the sums of each months values off the reports...BUT not every month will have values. I tried this by putting the total in the ID Number footer...but all it would add were the last two values (which might not even be the same months).
I hope this makes sense. Thanks in advance.
http://www.access-programmers.co.uk/forums/showthread.php?s=&postid=122934#post122934
I have done as she suggested with a report and subreports but my problem is now that if I have a report that has totals via the two queries. But I would like to be able to add the values from the two months.
To restate the problem as it relates to reports.
I have a main report run off of a table that has ID Number and name. (Grouped on ID Number).
Then off of that I have two sub reports by ID Number with values by Date By Month.
I would like to add the sums of each months values off the reports...BUT not every month will have values. I tried this by putting the total in the ID Number footer...but all it would add were the last two values (which might not even be the same months).
I hope this makes sense. Thanks in advance.
