calculation of total amount raised

[J. Weber]

Hello - We've created a database to manage a fund-raising event we are having. I'm trying to create a field that will show the total amount raised, across all records. I've fiddled with it a bit and can't get it to work - can only get it to calculate a total of the record I'm in, not across the whole database.

Ideally, I'd like it to calculate the sum of all records that may have information in the following fields: Sponsorship Amount, Table $, and Ticket $. If that's not possible, I can create a field that's called Total Amount This Record, add those fields up, and then have a Total Amount, All Records field, which would show total dollars raised, no matter what found set I'm in. Help!

Hope this makes sense. Tried to look in my user's guide but got even more confused ... Thanks!

[TSilvan]

Create your "Total Amount This Record" field as a stored calculation, then create a field called "Total Amount All Records" and define it as a Summary field to return the Total of the "Total Amount This Record" field.

[J. Weber]

Hi TSilvan - Thanks for your suggesstion. However, I'm such a novice user, I'm not sure what you mean! Can you give me a little more detail? Thanks!