novice having trouble getting a sum of multiple fields
I have a field that is a cal sum of two other fields ( one being a summary and the other a cal sum of 9 summary fields) the options are default for the summary fields. The first time i set this up it worked correctly but upon reopening up filemaker pro the field I'm getting a total in access of what it should be. Can someone direct me in how to do this correctly.
PhilModJunk,
These fields are tracking donations and do change monthly. Does this shed enough light on my conundrum?
Nope.
Spell out the field definitions.
Any relationships involved or are all the fields being used part of the same table?
What happens to the displayed values of these calculations when you close/reopen the file?
Are you always examining these values with the same exact found set or might reopening the file change the found set to give you a different result from what you expect?
Thanks your last question was where I blew it. Its now accurate.
More details on this would help.
One factor to look at: Your summary fields compute values drawing from all the records in the current found set. If you change the found set, you will change the results of any calculations that refer to them.