Posted 24 June 2006 - 01:04 PM
I have recordset with a field in called hours. How can I get all of the numbers in that field added together and displayed on the page via the use of some dynamic text? Bear in mind that there are more values being added to the recordset all the time.
Thanks in advance.
Posted 24 June 2006 - 01:53 PM
Donations gratefully received
|baaGrid| easy data tables - and more
|baaChart| easy line, column and pie charts
Posted 24 June 2006 - 06:54 PM
[!--sql--][div class=\'sqltop\']SQL[/div][div class=\'sqlmain\'][!--sql1--][span style=\'color:blue;font-weight:bold\']SELECT[/span] SUM(hours) AS total FROM tablename [!--sql2--][/div][!--sql3--]
Where do you write this? In the query section of the recordset or the dynamic text?
EDIT: Doesn't matter. Sorted.
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users