Subject Re: SUM From Mervyn Bick <invalid@invalid.invalid> Date Thu, 11 Jan 2024 15:41:46 +0200 Newsgroups dbase.getting-started On 2024/01/11 14:11, Jerry Frost wrote: > I have a table with a numerical field named ENTRYFEE containing both positive and negative numbers in the format 1.00,2.00,-3.00, etc. > Every time I SUM this field I get 0.00 ? > > sum entryfee to x > ? x > > I am still new at this so much appreciation for a possible solution. > Although you had only given the values as an example I was going to point out (tongue in cheek, I must add) that 1.00 + 2.00 - 3.00 = 0.00 The syntax is, however, correct so are you sure that 0.00 is wrong? If you are new to dBASE you should concentrate more on OOP (Object Oriented Programming) than the older DML commands. Have a look a the tutorial at   http://www.goldenstag.net/dbase/Tutorial/00_Preface.htm Mervyn.