Now nobody get mad at the use of evaluate...

        Evaluate(ValueList(yourQuery.yourColumn, " + "))

... I didn't add up all the numbers in my query, but give it a bash.

Ade

-----Original Message-----
From: Kevin Faulkner [mailto:[EMAIL PROTECTED]
Sent: 23 July 2003 12:24
To: '[EMAIL PROTECTED]'
Subject: [ cf-dev ] Sum of one column of resultset


Morning all,
   Is there a quick way to find the sum total of one column of a resultset
without having to loop through beforehand; I want to show on output each row
as a percentage, just figure looping twice has to be inefficient.

Cheers,
DISCLAIMER: This e-mail is confidential and may also be legally privileged.
If you are not the intended recipient, use of the information contained in
this e-mail (including disclosure, copying or distribution) is prohibited
and may be unlawful.  Please inform the sender and delete the message
immediately from your system.  This e-mail is attributed to the sender and
may not necessarily reflect the views of the patsystems Group and no member
of the patsystems Group accepts any liability for any action taken in
reliance on the contents of this e-mail (other than where it has a legal or
regulatory obligation to do so) or for the consequences of any computer
viruses which may have been transmitted by this e-mail. The patsystems Group
comprises patsystems plc and its subsidiary group of companies.

-- 
** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/

To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
For human help, e-mail: [EMAIL PROTECTED]

-- 
** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/

To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
For human help, e-mail: [EMAIL PROTECTED]

Reply via email to