Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 2 of 2 total
Thread FindNearest
Mon, May 28 2007 7:53 AMPermanent Link

"Jack Marsh"
Hi,

Is it possible to use FindNearest when the index contains columns that are
sorted in descending order?  I was hoping to be able to use it to find the
most recent date, before or equal to the key field in the FindNearest

Such that:

Tbl.FindNearest([Code,'31/12/2006')

Would move to say record (Code, '25/12/2006'); assuming that there was no
(Code,'31/12/2006').

Thanks,
Jack

Tue, May 29 2007 6:21 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Jack,

<< Is it possible to use FindNearest when the index contains columns that
are sorted in descending order? >>

Sure, no problem.

--
Tim Young
Elevate Software
www.elevatesoft.com

Image