Grabbing the maximum value of a field's contents (but not in an Sql statement)

[Chumley the Walrus]

I need to evaluate a field's maximum value and then do an if
conditional:
if rs("havesubP") = true and rs("displaygroup") < MAX then ....

whereas MAX represents the biggest value in the records for the
displaygroup field (an integer datatype). I get an "Either BOF or EOF
is True, or the current record has been deleted.." error if i put any
type of comparison number (of course MAX is not a vbscript keyword)
that is larger than my largest displaygroup value in the dbase , as I
will loop thru all the records once this condition is met.

thanks
chum

[William Morris]

Toss the recordset into an array. You can loop through it as many times as
you like then.

- Wm

--
William Morris
Product Development, Seritas LLC
Kansas City, Missouri

"Chumley the Walrus" <sp*******@yahoo.com> wrote in message
news:1e**************************@posting.google.c om...

I need to evaluate a field's maximum value and then do an if
conditional:
if rs("havesubP") = true and rs("displaygroup") < MAX then ....

whereas MAX represents the biggest value in the records for the
displaygroup field (an integer datatype). I get an "Either BOF or EOF
is True, or the current record has been deleted.." error if i put any
type of comparison number (of course MAX is not a vbscript keyword)
that is larger than my largest displaygroup value in the dbase , as I
will loop thru all the records once this condition is met.

thanks
chum

[Mark Schupp]

You need to check for eof in your loop. show the loop code.

--
Mark Schupp
Head of Development
Integrity eLearning
www.ielearning.com
"Chumley the Walrus" <sp*******@yahoo.com> wrote in message
news:1e**************************@posting.google.c om...

I need to evaluate a field's maximum value and then do an if
conditional:
if rs("havesubP") = true and rs("displaygroup") < MAX then ....

whereas MAX represents the biggest value in the records for the
displaygroup field (an integer datatype). I get an "Either BOF or EOF
is True, or the current record has been deleted.." error if i put any
type of comparison number (of course MAX is not a vbscript keyword)
that is larger than my largest displaygroup value in the dbase , as I
will loop thru all the records once this condition is met.

thanks
chum

[Chris Barber]

pobjRS.Sort = "[FIELD] DESC"
pdblMaxValue = pobjRS.Fields("FIELD").Value
pobjRS.Sort = vbNullString

Chris.
"Chumley the Walrus" <sp*******@yahoo.com> wrote in message
news:1e**************************@posting.google.c om...
I need to evaluate a field's maximum value and then do an if
conditional:
if rs("havesubP") = true and rs("displaygroup") < MAX then ....

whereas MAX represents the biggest value in the records for the
displaygroup field (an integer datatype). I get an "Either BOF or EOF
is True, or the current record has been deleted.." error if i put any
type of comparison number (of course MAX is not a vbscript keyword)
that is larger than my largest displaygroup value in the dbase , as I
will loop thru all the records once this condition is met.

thanks
chum