Who will answer it?

[firozfasilan]

The MAX function returns the highest value in a column. Syntax


"SELECT MAX(column) FROM table "

My question is how we will get the result.in visual basic

in record source.

[sukeshchand]

try this...........

Dim conn As New ADODB.Connection
Dim rs As New ADODB.Recordset
conn.Open "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Data Source=MyServer"
rs.Open "Select Max(Column) as MaxValue from Table1", conn, adOpenForwardOnly, adLockReadOnly
MsgBox rs!MaxValue
rs.Close

[firozfasilan]

Thank you ..................................

[sukeshchand]

welcome.......

[debasisdas]

its so simple

[hariharanmca]

its so simple

Nothing is Simple Until You Know