How to get last row before any date

[inhisglory]

Hello all...
I want to get the last transaction on a date before.
Example : want to get the last trans (row) before Juli,1st 2001

Thank you
Yahya

 

[tlbroadbent]

Use the following query as an example.

Select Top 1 *
From TransTbl
Where TransDate<'jul 1 2001'
Order By TransDate Desc Terry Broadbent
Please review faq183-874.

&quot;The greatest obstacle to discovery is not ignorance -- it is the illusion of knowledge.&quot; - Daniel J Boorstin