Entry

What is the correct syntax for summing a field returned in a recordset?

May 20th, 2000 06:54
unknown unknown, Ryan Trudelle-Schwarz

Use the sum function within your db via the sql string.
Something like:

SELECT SUM(cases) as sum_cases FROM whatever WHERE whatever


Of course, you can return other fields as well, that's just an example.