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
