putting SQL result on a Msgbox

A

ali

I have an SQL

(Select max([date]) from Table1)

this returns the date of my latest record from Table1.
 
M

Morris

I have an SQL

(Select max([date]) from Table1)

this returns the date of my latest record from Table1.

---------------------------------------------------------------------------­---------
I'd like to show the result on a msgbox, meaning, when user clicks a button,
i'll launch the MsgBox and the result should be placed on the msgbox.

What should i do , dear experts ? !
Click to expand...

I'd do it using an ADODB recordset.

dim rstData as ADODB.recordset
dim strSQL as string

strsql = "Select max([date]) AS MaxOfDate from Table1"
rstdata.open strsql

if rstdata.BOF then
msgbox "Query returned no results"
else
msgbox "The latest date is: " & rstdata("MaxOfDate")
endif

set rstdata = nothing
 
Top