I set up a database that keeps track of all the work I do and has all the standard fields... job number, client, date, fees, etc... To send out invoices every month, I've set up a button with a simple script to search by a range of dates as well as by the specific client and throw it into a list layout. This works fine. What I'd also like to do is be able to do is total the fees for that date range. When I define a field as a number and then have it auto-calc the sum of the fees, it only spits back the fees of one of the jobs that results from the find and doesn't add anything. I've set up a "Total Fees" field and a "Monthly Fees" field. I'd also like to be able to add up the total fees of my entire database. How can I add up the total fees? Also how can I get the monthly fees to total after I perform the find?... and can I add this monthly addition part to the simple search script that is on my search button?
Thanks!
Mark
