using Max function (SQL)

[Mzgee]

Can i ask for a sample format using MAX ( sql query) in vb 6.0

[willakawill]

Hi. Use of MAX() is the same for vb or any language because it is used in embedded SQL statements e.g.

SELECT MAX([fieldname]) AS TheMax FROM [tablename]

[arunbalait]

Hi

Its same as that of using other sql statements in VB. But before that declare oledb command or recordset.