From: "Robert F. Tulloch" <tultalk@...>
Sent: Friday, July 27, 2001 1:14 PM

>
> So how do you set up the query to get the previous rec when current PK

is 100 and

> prev PK is 87?
>

Select Max(IDField) from Table where IDField < CurrentID into :NewID

Woody