Re: Viewing data from the previous row

2001-04-28 Thread Bob Hall
rnouk" <[EMAIL PROTECTED]> >Cc: <[EMAIL PROTECTED]> >Sent: Friday, April 27, 2001 12:37 PM >Subject: Re: Viewing data from the previous row > > > > Roger Karnouk wrote: > > > > > > Is it possible in a Select query to get values from the previous

Re: Viewing data from the previous row

2001-04-27 Thread Eric Fitzgerald
ECTED]> Cc: <[EMAIL PROTECTED]> Sent: Friday, April 27, 2001 12:37 PM Subject: Re: Viewing data from the previous row > Roger Karnouk wrote: > > > > Is it possible in a Select query to get values from the previously read row > > in order to do things like cumulative sum

Re: Viewing data from the previous row

2001-04-27 Thread Steve Ruby
Roger Karnouk wrote: > > Is it possible in a Select query to get values from the previously read row > in order to do things like cumulative sums or other formulas which require > the previous value in order to calculate the current value. > > ex. > day current sales cumu_total > - --

Viewing data from the previous row

2001-04-27 Thread Roger Karnouk
Is it possible in a Select query to get values from the previously read row in order to do things like cumulative sums or other formulas which require the previous value in order to calculate the current value. ex. day current sales cumu_total - --- 1