By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
464,728 Members | 1,120 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 464,728 IT Pros & Developers. It's quick & easy.

Report in Access project

P: n/a
MVM
Hello everyone-
I am having a little trouble calculating totals in an access report. The
report is part of an Access Project which gets its data from SQL Server
2000. I have the calculations executing in the On_Format event of the Group
footer. It works fine if all of the group records are on the same page, but
it doesn't work if the group is split between two pages, then it re-adds the
values from the second page. For instance if I have 5 items that cost $5 on
page 1 and 1 item that cost $5 on page 2, my total cost for the group shows
$35 instead of $30, because it runs the On_Format event twice for the item
on the second page. Any ideas?
Thanks!
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply

P: n/a
On Tue, 16 Dec 2003 21:50:57 GMT, "MVM" <mu********@hotmail.com>
wrote:

That's why that event has a FormatCount argument.
-Tom.
Hello everyone-
I am having a little trouble calculating totals in an access report. The
report is part of an Access Project which gets its data from SQL Server
2000. I have the calculations executing in the On_Format event of the Group
footer. It works fine if all of the group records are on the same page, but
it doesn't work if the group is split between two pages, then it re-adds the
values from the second page. For instance if I have 5 items that cost $5 on
page 1 and 1 item that cost $5 on page 2, my total cost for the group shows
$35 instead of $30, because it runs the On_Format event twice for the item
on the second page. Any ideas?
Thanks!


Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.