Subject Re: SUM From Akshat Kapoor <akshat.kapoor@kapoorsons.in> Date Fri, 12 Jan 2024 19:52:47 +0530 Newsgroups dbase.getting-started Good Evening Jerry, > > The entryfee field does have several more positive and negative entries. The SUM(amount) worked perfectly until a few days ago when it now produces only a zero value? The correct result should be a positive number with the values I have in my table now. Option 1 I would recommend that you make a copy of the table. Blank out all the other fields and post the table. Some thing is amiss which I am unable to guess now. Option 2 Add a logical field. Set the field to true for 5 or 6 rows. Try sum entryfee to x for newfield = true ?X If this is non zero then there is some issue with data and not with dbase. Regards Akshat