I am setting up DBman to use for an online donation system for a nonprofit organization - http://www.cityrescuemission.org - City Rescue Mission.

When a user makes a donation, a separate new record will be created. I'd like to be able to create a reporting page that lists all the donation information in a table with a total dollar figure at the bottom that simply adds up all the numbers in the "Amount" field.

Can anyone tell me how this is done?

Thanks!!!

Michael Liimatta, Director of Education
Rescue College, Kansas City MO USA

Michael:

Check the FAQ noted below under the section "Calculate / Counts" and you will find various thread references for doing your calculations.

In the section "Calculate / Counts" you will also find a thread called "Creating A Reports Routine" which may provide the solution you are looking for.

Hope this helps


Unoffical DBMan FAQ
http://webmagic.hypermart.net/dbman/