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.

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

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

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.