Using ADO, how did you write a query to select the maximim value in a field? ???
Select * from Table ...
Printable View
Using ADO, how did you write a query to select the maximim value in a field? ???
Select * from Table ...
Try a Select statement like the following. Use the "AS" feature to save the maximum value in a variable.
[code]
rsMax.Open "Select max(user_id) AS maxValue from user", dbFBI, adOpenDynamic, adLockReadOnly
MsgBox rsMax!maxValue
I had a few probelms with VBNULL but worked through them. Thank you for the help.