Also, it should be SUM OF vPound -- No leading dot --- Lawrence Lustig <[EMAIL PROTECTED]> wrote: > > but I have not > > been able to do the > > total of the POUND variable (vPOUND). I tried to do > > SUM OF .vPOUND and > > it comes up as zero. > > First off, I've found that to use SUM OF in a report, > you must have SET ZERO ON before running the report. > > However, you might want to consider basing the report > on a view, having the view calculate the Pound amount, > and then using a DBCalc to SUM that column. This > approach removes the logic from the report and lets > you use the view for as many different reports as you > want. > -- > Larry > >
===== Albert Berry Management Consultant RR2 - 1252 Ponderosa Drive Sparwood BC, V0B 2G2 Canada (250) 425-5806 (250) 425-7259 (708) 575-3952 (fax) [EMAIL PROTECTED]
