On Format event

[dcorey]

Hi, everyone. So, nobody responded to my last question... but I'm not hurt.

How about this one: I want to sum the fields in the detail section of a report. What's the most eloquent way to get around the fact that Access' On Format event occurs twice? The help section says the On Retreat event is useful for undoing calculations you only want done once, but what is the most foolproof way?

Thanks for any help!

 

[Rich]

Why do you need to use an event, what's wrong with the Sum function?
Couldn't find your last question, post a link to it.

[This message has been edited by Rich (edited 12-07-2001).]

 

[dcorey]

Thanks for the reply, Rich! I should have been a little more specific: The report lists outstanding invoices for a company, and calculates and displays how many days old each invoice is. So I do use the Sum function for a grand total (which works fine), but I also want to add up amounts according to how much overdue they are (between 31 and 60 days, 61-90, etc.) and multiply that by the appropriate finance charge. That's where I figured I needed to use an event. Any suggestions with all that?

Thanks again!

(Oh, and if you answer this, you'll basically answer my previous question.)

[This message has been edited by dcorey (edited 12-07-2001).]

 

[Pat Hartman]

Use the FormatCount property to determine how many times a Format event is executed..