SQL and Access 2000

[Gordo]

Hello,

I would like to Execute this Select Statement...

SELECT MAX(VisitorID) FROM Visitors.

Is there any way to store the result directly into a VB variable??

lngVisitorID = ???

Thanks!!!

[MacDermott]

You mean like this?
lngVisitorID=DMax("VisitorID","Visitors")

HTH
- Turtle

"Gordo" <gm****@yahoo.com> wrote in message
news:wQ*********************@news1.calgary.shaw.ca ...

Hello,

I would like to Execute this Select Statement...

SELECT MAX(VisitorID) FROM Visitors.

Is there any way to store the result directly into a VB variable??

lngVisitorID = ???

Thanks!!!

[T. Glaser]

"MacDermott" <ma********@mindspring.com> wrote in message news:<Jw*******************@newsread2.news.atl.ear thlink.net>...

You mean like this?
lngVisitorID=DMax("VisitorID","Visitors")

HTH
- Turtle

"Gordo" <gm****@yahoo.com> wrote in message
news:wQ*********************@news1.calgary.shaw.ca ...

Hello,

I would like to Execute this Select Statement...

SELECT MAX(VisitorID) FROM Visitors.

Is there any way to store the result directly into a VB variable??

lngVisitorID = ???

Thanks!!!

Hi,

dim dbs as database
dim rst as recordset

set dbs = currentdb
set rst = dbs.openrecordset("SELECT MAX(VisitorID) AS M FROM Visitors")

if rst.recordcount >0 then
lngVisitorID = rst!M
else
lngVisitorID = 0 'or something else
end if

rst.close
dbs.close

Hope this helps (maybe not the best, but a working solution)

Gr. T