ACCESS2000 SQL Count Function / Where is value returned

[m3hosting]

I am trying to use the count function.

SELECT COUNT(*)FROM tblCHGLOG

Where is the world is the count? How can I specify a variable for it to be placed into for later processing.

Thanks in advance

 

[JoeMiller]

MyVar = DCount("*","tblCHGLOG)

Joe Miller
joe.miller@flotech.net

 

[m3hosting]

I am missing something. I am using VBS in ASP querying a ACCESS2000 database.

MyVar = DCount("*","tblCHGLOG)

returns DCount not defined.I assumed DCount was some Jet function.

Thanks again for any advise.

 

[JoeMiller]

DCount is a VBA function, sorry since you did not mention ASP I didn't know this would not apply. Unfortunately I cannot help you with ASP.

Joe Miller
joe.miller@flotech.net

 

[tlbroadbent]

Change the query to provide a name (alias) for the count.

SELECT COUNT(*) As RecCnt FROM tblCHGLOG Terry L. Broadbent
faq183-874 contains some tips and ideas for posting questions in these forums. Please review it and comment if you have time.
NOTE: Reference to the FAQ is part of my signature and is not directed at any individual.