select min value

Hi,

This is my SQL code,
"SELECT MIN(TotalLeft) FROM Burn"


And this is where I ask to see the result.

Line 275 = <%response.write recordset("TotalLeft")%>

I am getting this error:
ADODB.Recordseterror '800a0cc1'


Item cannot be found in the collection corresponding to the requested name or ordinal. /Content/DLRC/DLRC_Interface/CD_DVD_log.asp, line 275

Any insight? My SQL code is correct and works in my Access Database....

Thanks!

Change your sql statement to this

Thanks, that was a much quicker fix than me sitting here trying to figure it out....much appreciated.

Read my signature regarding "Helpful Posts" and adding reputation points.

Glad, it worked for you.

Gottcha! One more thing....and I will do your request.

How do I do more than one min value?

I have this:

"SELECT MIN(TotalLeft) as TotalLeft AND MIN(DVDTotal) as DVDTotal FROM Burn"

and I am getting an error..........thanks, you always are very helpful.

try this

It's weird, it is not selecting the lowest DVDTotal.