Select Max(Score) From tblename ?<BR>Should get you started...<BR><BR>You can create these queries directly inside access, then copy paste to your asp script will little changes needed...<BR>Should take a look at it.
response.write rs1(0)<BR><BR>BTW qryMax is the name of your table?I thought it was,but when I reread your post ,i get a feeling that it might be the name of the query ?If so ,that wont work.<BR><BR>I am not sure how to call query from asp,but simply the name of the query should do it ? Not sure,better wait for the regulars here.<BR>
I had given you this<BR>Select Max(Score) From tblename<BR><BR>And then you showed after you tried this<BR>"SELECT Max of Score FROM qryMax;"<BR>[How you got that I have no clue...]<BR><BR>Then Flakes gave you<BR>"SELECT Max(Score) FROM qryMax;" <BR>And you said it worked...<BR><BR>I think you need to do 2 things.<BR>1. Pay closer attention to what people give you.<BR>2. Get a good book and do dome reading. This is kinda the basics..<BR><BR>That said, your asking how to print the value to asp page...<BR>Again if you did a bit of reading you would pick up on this...<BR><BR>You can give an Alius field name in the select part of the statement...<BR><BR>"SELECT Max(Score) AS ThisIsMyMaxValue FROM qryMax;" <BR><BR>Response.Write rs("ThisIsMyMaxValue")<BR><BR>Of course ThisIsMyMaxValue can be any name you want it to be so long as it is not a SQL Key word.<BR>