Addition with record results
Posted on 2004-11-08
Ok, I have an ASP app I'm building. I have a page that returns results from an Access database based on some variables from a form. One of the fields it returns is "hours worked", and I want to add the hours from all the returned records, but I don't know where to start.
For example: Search for records between a certain date range, completed by a certain staff member. It returns 5 records and the hours worked are: 1.5, 2.5, 8.0, 5.0 and 3.5 for each record returned respectively. I'd like to add all of those up to show total hours worked as 20.5 hrs. Thanks for the help.