How to lookup the max value of the column

[sabavno]

Hi

I have a table called 'CONFIGURATION' that has a numeric 'ModelID' field.
How would I lookup the max value of that field from the vba code?

Thanks

 

[KenReay]

Hi

You could use dMax() See help for syntax, or you could use a recordset based on select statement ordered by ModuleId Desc then read the first row.

Regards
Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
UK
kenneth.reay@talk21.com

 

[rgbanse]

Sabavno,
Give this a try

Function FindMaxValue()
Dim MaxValue As String
MaxValue = DLookup("Max([FieldName])", "TableName&quot
MsgBox MaxValue
End Function

RGB