Subject Re: SUM From Jerry Frost <ealer@comcast.net> Date Fri, 12 Jan 2024 07:13:09 -0500 Newsgroups dbase.getting-started 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. > 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.