Hi,

I have the following problem and I dont know how to fix it withing filemaker
(pro 7.0v3):

The database contains 3 field:
* date
* number
* total of number until date

The records are not created in ascending order on date. I would like to have
the field "total of number until date" containing the total of the numbers
until the date of the current record. I tried with summary fields, but then
all the numbers are summarized. Is there any solution so when I enter a date
and a number, filemaker automatically calculates the total of the numbers
until that date?

Thanx in advance,


Jurgen Lemmens

In article <42ca218e$0$24258$ba620e4c (AT) news (DOT) skynet.be>, "Jurgen Lemmens"
<jurgen.lemmens (AT) skynet (DOT) be> wrote:

Nobody else seems to have answered this one, so I'll give it a stab.

I *THINK* in FileMaker 7 you should be able to create a
self-relationship that picks up all records "less than and equal to
'date'", and then use the Sum function with that relationship to total
the related field values ... but unfortunately I've never used
FileMaker 7, so I don't really know if that's correct or how these new
relationship ablities work. \

Basically if it works the way I think it does you can create a new
relationship:

PastRecords Date >= SameFile:ate

and then you can sum the records using:

TotalNumberUntilDate
= Sum (PastRecords::Number)

This can be either a calculation field (unstored so that it continually
updates) or an auto-enter claculation for a Number field (if you want
the CURRENT total to be stored with each record).



Helpful Harry
Hopefully helping harassed humans happily handle handiwork hardships ;o)