SQL Easy

[James Stanich]

Using ADO, how did you write a query to select the maximim value in a field? ???

Select * from Table ...

[jbart]

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

[James Stanich]

I had a few probelms with VBNULL but worked through them. Thank you for the help.