Subject Re: SUM From Jerry Frost <ealer@comcast.net> Date Fri, 12 Jan 2024 14:45:57 -0500 Newsgroups dbase.getting-started Akshat Kapoor Wrote: > 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 Thank you Alshat. I'll try it. I have found that it is only certain records that are affected.