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! Yo

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

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 cal