Techniques for queries on a series?

2009-11-17 Thread Jan Steinman
I often need a pattern where one record refers to the one before it, based on the order of some field. For example, a vehicle log, in which the field odometer is the current odometer reading upon an event, such as a trip completion, fueling, maintenance, etc. Very often one wants to

Re: Techniques for queries on a series?

2009-11-17 Thread Peter Brawley
Jan, I often need a pattern where one record refers to the one before it, based on the order of some field. Some ideas under Sequences at http://www.artfulsoftware.com/infotree/queries.php. PB Jan Steinman wrote: I often need a pattern where one record refers to the one before it,

Re: Techniques for queries on a series?

2009-11-17 Thread Jan Steinman
On 17 Nov 09, at 10:41, Peter Brawley wrote: I often need a pattern where one record refers to the one before it, based on the order of some field. Some ideas under Sequences at http://www.artfulsoftware.com/infotree/queries.php . Thanks, Peter! What a marvellous resource! You