[Download-List] Total an EVAL statement?

Brian Pollitt bpollitt at dacc.edu
Wed Oct 15 16:44:39 EDT 2008


Hi everyone,

I am wondering if it is possible to total an EVAL statement that's 
calculating numbers?
Example:

The EVAL is taking a starting amount (ie 1500) and subtracting an 
expensed amount (ie 500), thus the remaining amount would be 1000. I'm 
trying to get a grand total for the remaining amount. The closest I've 
gotten is that the grand total displays the last record's remaining amount.

Any ideas?

Thanks!
-- 
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
        Brian J. Pollitt
         Programmer/DBA
   Administrative Data Systems
Danville Area Community College
      2000 East Main Street
       Danville, IL 61865
         (217)443-8854
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
-------------- next part --------------
A non-text attachment was scrubbed...
Name: bpollitt.vcf
Type: text/x-vcard
Size: 357 bytes
Desc: not available
URL: <http://mail.cedarville.edu/pipermail/download-list/attachments/20081015/fd002ab9/attachment.vcf>


More information about the download-list mailing list