How do I get a count of the number of records when a query is performed?

Hi,
something like
SELECT COUNT(*) FROM Table

--
Cheers,
Jon
Microsoft MVP - FP

Dan wrote:
> How do I get a count of the number of records when a query is
> performed?

>-----Original Message-----
>How do I get a count of the number of records when a
>query is performed?

If you're using an ADO recordset, the RecordCount
property may contain the information you're looking for.

Set rsMine = New ADODB.Recordset
sql = "select * from mytable "
rsMine.Open sql, strCnxn
NrOfRecs = rsMine.RecordCount

However, for some cursor types and cursor locations, this
property may always be zero. If you encounter this, try a
different cursor type or cursor location, such as

rsMine.CursorLocation = adUseClient
rsMine.Open sql, strCnxnm, adOpenStatic

Jim Buyens
Microsoft FrontPage MVP
http://www.interlacken.com
Author of:
*----------------------------------------------------
|\---------------------------------------------------
|| Microsoft Office FrontPage 2003 Inside Out
||---------------------------------------------------
|| Web Database Development Step by Step .NET Edition
|| Microsoft FrontPage Version 2002 Inside Out
|| Faster Smarter Beginning Programming
|| (All from Microsoft Press)
|/---------------------------------------------------
*----------------------------------------------------

Im calling a query in access to display users registered for a certian course. I want it to list the users registered and show a count of how many users have registered for that course

----- Jim Buyens wrote: ----

>-----Original Message----
>How do I get a count of the number of records when
>query is performed

If you're using an ADO recordset, the RecordCount
property may contain the information you're looking for

Set rsMine = New ADODB.Recordse
sql = "select * from mytable
rsMine.Open sql, strCnx
NrOfRecs = rsMine.RecordCoun

However, for some cursor types and cursor locations, this
property may always be zero. If you encounter this, try a
different cursor type or cursor location, such a

rsMine.CursorLocation = adUseClien
rsMine.Open sql, strCnxnm, adOpenStati

Jim Buyen
Microsoft FrontPage MV
http://www.interlacken.co
Author of
*---------------------------------------------------
|\--------------------------------------------------
|| Microsoft Office FrontPage 2003 Inside Ou
||--------------------------------------------------
|| Web Database Development Step by Step .NET Editio
|| Microsoft FrontPage Version 2002 Inside Ou
|| Faster Smarter Beginning Programmin
|| (All from Microsoft Press
|/--------------------------------------------------
*---------------------------------------------------

Can I use the same idea with the acception of counting from a query not a tabl

SELECT COUNT (*) FROM usercourses (view

----- Jon Spivey wrote: ----

Hi
something lik
SELECT COUNT(*) FROM Tabl

-
Cheers
Jo
Microsoft MVP - F

Dan wrote
> How do I get a count of the number of records when a query i
> performed

Are you doing this with:

o The Frontpage Database Results Wizard?
o Custom ASP code?
o Custom ASP.NET code?
o Something else?

Jim Buyens
Microsoft FrontPage MVP
http://www.interlacken.com
Author of:
*----------------------------------------------------
|\---------------------------------------------------
|| Microsoft Office FrontPage 2003 Inside Out
||---------------------------------------------------
|| Web Database Development Step by Step .NET Edition
|| Microsoft FrontPage Version 2002 Inside Out
|| Faster Smarter Beginning Programming
|| (All from Microsoft Press)
|/---------------------------------------------------
*----------------------------------------------------


>-----Original Message-----
>Im calling a query in access to display users registered
for a certian course. I want it to list the users
registered and show a count of how many users have
registered for that course.
>
> ----- Jim Buyens wrote: -----
>
> >-----Original Message-----
> >How do I get a count of the number of records when
a
> >query is performed?
>
> If you're using an ADO recordset, the RecordCount
> property may contain the information you're looking
for.
>
> Set rsMine = New ADODB.Recordset
> sql = "select * from mytable "
> rsMine.Open sql, strCnxn
> NrOfRecs = rsMine.RecordCount
>
> However, for some cursor types and cursor
locations, this
> property may always be zero. If you encounter this,
try a
> different cursor type or cursor location, such as
>
> rsMine.CursorLocation = adUseClient
> rsMine.Open sql, strCnxnm, adOpenStatic
>
> Jim Buyens
> Microsoft FrontPage MVP
> http://www.interlacken.com
> Author of:
> *---------------------------------------------------
-
> |\--------------------------------------------------
-
> || Microsoft Office FrontPage 2003 Inside Out
> ||--------------------------------------------------
-
> || Web Database Development Step by Step .NET
Edition
> || Microsoft FrontPage Version 2002 Inside Out
> || Faster Smarter Beginning Programming
> || (All from Microsoft Press)
> |/--------------------------------------------------
-
> *---------------------------------------------------
-
>
>
>.
>

DRW and Access queries in combinatio

----- Jim Buyens wrote: ----

Are you doing this with

o The Frontpage Database Results Wizard
o Custom ASP code
o Custom ASP.NET code
o Something else

Jim Buyen
Microsoft FrontPage MV
http://www.interlacken.co
Author of
*---------------------------------------------------
|\--------------------------------------------------
|| Microsoft Office FrontPage 2003 Inside Ou
||--------------------------------------------------
|| Web Database Development Step by Step .NET Editio
|| Microsoft FrontPage Version 2002 Inside Ou
|| Faster Smarter Beginning Programmin
|| (All from Microsoft Press
|/--------------------------------------------------
*---------------------------------------------------


>-----Original Message----
>Im calling a query in access to display users registered
for a certian course. I want it to list the users
registered and show a count of how many users have
registered for that course
>> ----- Jim Buyens wrote: ----
>>>-----Original Message----
>>How do I get a count of the number of records when

>>query is performed
>> If you're using an ADO recordset, the RecordCount
> property may contain the information you're looking
for
>> Set rsMine = New ADODB.Recordse
> sql = "select * from mytable
> rsMine.Open sql, strCnx
> NrOfRecs = rsMine.RecordCoun
>> However, for some cursor types and cursor
locations, this
> property may always be zero. If you encounter this,
try a
> different cursor type or cursor location, such a
>> rsMine.CursorLocation = adUseClien
> rsMine.Open sql, strCnxnm, adOpenStati
>> Jim Buyen
> Microsoft FrontPage MV
> http://www.interlacken.co
> Author of
> *--------------------------------------------------

> |\-------------------------------------------------

> || Microsoft Office FrontPage 2003 Inside Ou
> ||-------------------------------------------------

> || Web Database Development Step by Step .NET
Editio
> || Microsoft FrontPage Version 2002 Inside Ou
> || Faster Smarter Beginning Programmin
> || (All from Microsoft Press
> |/-------------------------------------------------

> *--------------------------------------------------

>>>
>

Well, with the DRW, you have to put two Database Results
Regions on the same page -- one to display the data and
another -- with the same WHERE clause -- to display the
COUNT(*) value.

In a custom ASP page, you can just access the open
recordset's RecordCount property (provided you use a
cursor type and cursor location that supports this
property).

Jim Buyens
Microsoft FrontPage MVP
http://www.interlacken.com
Author of:
*----------------------------------------------------
|\---------------------------------------------------
|| Microsoft Office FrontPage 2003 Inside Out
||---------------------------------------------------
|| Web Database Development Step by Step .NET Edition
|| Microsoft FrontPage Version 2002 Inside Out
|| Faster Smarter Beginning Programming
|| (All from Microsoft Press)
|/---------------------------------------------------
*----------------------------------------------------


>-----Original Message-----
>DRW and Access queries in combination
>
> ----- Jim Buyens wrote: -----
>
> Are you doing this with:
>
> o The Frontpage Database Results Wizard?
> o Custom ASP code?
> o Custom ASP.NET code?
> o Something else?
>
> Jim Buyens
> Microsoft FrontPage MVP
> http://www.interlacken.com
> Author of:
> *---------------------------------------------------
-
> |\--------------------------------------------------
-
> || Microsoft Office FrontPage 2003 Inside Out
> ||--------------------------------------------------
-
> || Web Database Development Step by Step .NET
Edition
> || Microsoft FrontPage Version 2002 Inside Out
> || Faster Smarter Beginning Programming
> || (All from Microsoft Press)
> |/--------------------------------------------------
-
> *---------------------------------------------------
-
>
>
> >-----Original Message-----
> >Im calling a query in access to display users
registered
> for a certian course. I want it to list the users
> registered and show a count of how many users have
> registered for that course.
> >> ----- Jim Buyens wrote: -----
> >>>-----Original Message-----
> >>How do I get a count of the number of records
when
> a
> >>query is performed?
> >> If you're using an ADO recordset, the
RecordCount
> > property may contain the information you're
looking
> for.
> >> Set rsMine = New ADODB.Recordset
> > sql = "select * from mytable "
> > rsMine.Open sql, strCnxn
> > NrOfRecs = rsMine.RecordCount
> >> However, for some cursor types and cursor
> locations, this
> > property may always be zero. If you encounter
this,
> try a
> > different cursor type or cursor location,
such as
> >> rsMine.CursorLocation = adUseClient
> > rsMine.Open sql, strCnxnm, adOpenStatic
> >> Jim Buyens
> > Microsoft FrontPage MVP
> > http://www.interlacken.com
> > Author of:
> > *---------------------------------------------
------
> -
> > |\--------------------------------------------
------
> -
> > || Microsoft Office FrontPage 2003 Inside
Out
> > ||--------------------------------------------
------
> -
> > || Web Database Development Step by Step .NET
> Edition
> > || Microsoft FrontPage Version 2002 Inside
Out
> > || Faster Smarter Beginning Programming
> > || (All from Microsoft Press)
> > |/--------------------------------------------
------
> -
> > *---------------------------------------------
------
> -
> >>>.
> >
>.
>

Hello Jon,

Thank you very much for the solution. It solved my problem.


Regards,

Leo

"Jon Spivey" wrote:

> Hi,
> something like
> SELECT COUNT(*) FROM Table
>
> --
> Cheers,
> Jon
> Microsoft MVP - FP
>
> Dan wrote:
> > How do I get a count of the number of records when a query is
> > performed?
>
>
>