Report in Access project

[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!

[Tom van Stiphout]

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!