Running Totals and #of records
I can't seem to find a way to keep a running total in a list of entries. For example, if I wanted to do a check register, how would I keep a running balance. Other databases I have used would let you code a reference to 'this field in previous entry'. In other words, you didn't have to reference a particular record - the system new it should always reference the entry preceding the current one. Also, is it possible to use the number of records in a database in calculations, to keep running averages, etc?
samhogue