Sum field for flat database? How?

[Andrew5]

Sorry to ask such a simple question: I have many DB's with summary fields with child tables, but now I am making a flat DB. It's a checkbook, and I merely need a field that gives me a sum of one field for all of the records. A check is recorded as a negative number and a deposit as a positive number. How to make calculated summary field of that field in this flat DB? THANK YOU in advance.

[bcooney]

Use a, um, summary field Total of. Be careful of found sets. Or, use a self-join cartesian relationship and Sum ( selfjoin::numberfield).

[LaRetta]

Hi Andrew, as Barbara says, you need to create a summary field. When you create it, specify running total. :-)

[Andrew5]

Oh, woe is me! Thank you. This is was very easy and I had forgotten. If you get away from making DB's on FM, one does tend forget where various functions are tucked away.