I tried that, it displays an error 2187 "illegal number of items for expression
John -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of A. Razzak Memon Sent: Friday, August 27, 2004 5:21 PM To: RBG7-L Mailing List Subject: [RBG7-L] - Re: SUM in reports John, Try this: vTOT_PUR = SUM OF tPrice IN Purchase WHERE Inv# = .vNEW_INV_NO Very Best R:egards, Razzak. At 05:18 PM 8/27/2004 -0400, you wrote: >Is this a valid expression for a variable in a report? > >vTOT_PUR = (sum(tprice)) in purchase where inv# = .vNEW_INV_NO > >No errors are created when I enter the expression but when it executes it >comes up with the wrong total. > >John
