Hi

I have a very simple SQL query like this:
strSQL = "select max(fieldname) from tablename"

'Open connection ...
'Excute query...
'Until here everything goes well ...
dim iMax as integer
'Error getting value
iMax = rs.Fields("fieldname").value

But it doesn't work. Anyone any idea?

Greetings,
Jay