If this answers your question please tick the 
(upper left area of answer). It helps others to know there was an accepted answer.
Thank you. Where can I see the the database that I am using?
I used the same formula, but the totals are not showing.
Saw it already. Yes I am using HSQLDB embedded.
By the way, the field type of fields “Jan, Feb, March and April” are NUMBER(NUMERIC).
@fredprom@yahoo.de,
Your state it is not showing totals but do not know what you have done. Edit your question and post a sample file containing the problem but eliminate any personal or confidential information.
Thank you. May I send you the complete file to your Email? Of course without personal infos.
My email address: fredprom@yahoo.de
How do I post a sample file here?
Edit your question - edit lower right corner of your question. Then use toolbar (upper left in question) and select paperclip icon. See → How do I attach a file to my question/answer?
Hi, were you able to open the attached file? Thanls.
There is no attached file in your question. Have been waiting. I was the last to edit your question on 2021-01-25
Oh sorry. I thought I’ve sent it already. Anyway, here it is. I hope it works.
Oh sorry. I thought I’ve sent it already. Anyway, here it is. I hope it works.
Personally I do not use/like the Query Design mode. Has some problems and takes away from using/learnng actual SQL.
The problem you have is that you have numeric fields which contain NULL. A NULL is nothing. NULL with anything is NULL. Causes much problems. If you place zeroes in your empty “TithesXX” fields, the totals work fine.
You may want to read up on setting default values. This can also be overcome with SQL but that is another journey.
I attached the file already. Did you see any problem with the file? Thanks.
Please look at the comment just above yours. There I already posted the problem and answer almost two days ago. It was posted shortly after your posting of the sample.
You need to check your notifications (messages). New are signified to right of your User name as a red envelope. See → Notification icon.
Have directed you to that post before for attaching a file. You probably should review the entire post.
Thanks for an immediate answer. I did waht you suggested setting the default values to 0. Also changed the format to EUR. Still didn"t work. What other field type can I use in this case? Do ypou have ang suggestions on how I can arrive at the totals?
Thanks a lot. Problem solved.
Btw, how can delete a macro the easiest way? Thanks.
That is a different topic from the original question and should be asked as a new question. Questions asked such as this will not be easily found by others looking for the same answer.
Not to stiff you on some type of answer, the easiest way is to go to the Basic IDE Tools->Macros->Edit Macros and delete from there. If you are referring to the situation in your file, that is more complex and I don’t even know how you got it into that situation. That should be a different question.
Ok. Thanks.