End Of Recordset!!

[Adam Knight]

Mostlikely a very simple answer to this question.

I am wanting to move to the last record in a recordset and extract a value
from it.
When i go move last and move previous i get an error saying catch fetch
backwards.

I augment my ignorance,..but here goes..how do i do this ??

[Ken Schaefer]

a) Use the ORDER BY clause in your SQL statement to reorder the recordset in
the order that you want

-or-

b) If you need all the records, but you need to use the last value first,
then:

Set objRS = objConn.Execute(strSQL)

' Put results into a VBScript array
If not objRS.EOF then arrResults = objRS.GetRows

' Get rid of ADO object
objRS.Close
Set objRS = Nothing
objConn.Close
Set objConn = Nothing

' Get last value
If isArray(arrResults) then
strLastValue = arrResults(0, UBound(arrResults(2) -1)
End If

Cheers
Ken
"Adam Knight" <aj.knight@optusnet.com.au> wrote in message
news:uEMiS%23qeDHA.1088@TK2MSFTNGP10.phx.gbl...
: Mostlikely a very simple answer to this question.
:
: I am wanting to move to the last record in a recordset and extract a value
: from it.
: When i go move last and move previous i get an error saying catch fetch
: backwards.
:
: I augment my ignorance,..but here goes..how do i do this ??
:
: