|
 |
access_asp thread: Counting Query Rows in Access
Message #1 by "Binu" <beanz75@a...> on Fri, 22 Mar 2002 01:55:38
|
|
Hello-
How can I count the number of rows in an Access query. I have success
using the RecordCount property of the RecordSet object to count the number
of records in a table, but it doesnt work so well for a stored procedure
in Access.
Message #2 by Abdul Sami <abdul_sami_20@y...> on Thu, 21 Mar 2002 22:47:47 -0800 (PST)
|
|
You can use a variable, having value starting from 0 and
increment for var+1 on each row within in the while loop.
--- Binu <beanz75@a...> wrote:
> Hello-
>
> How can I count the number of rows in an Access query. I have
> success
> using the RecordCount property of the RecordSet object to count
> the number
> of records in a table, but it doesnt work so well for a stored
> procedure
> in Access.
=====
Abdul Sami
__________________________________________________
Do You Yahoo!?
Yahoo! Movies - coverage of the 74th Academy Awards®
http://movies.yahoo.com/
Message #3 by "Ken Schaefer" <ken@a...> on Sat, 23 Mar 2002 13:59:40 +1100
|
|
www.adopenstatic.com/faq/recordcountalternative.asp
www.adopenstatic.com/faq/recordcounterror.asp
Cheers
Ken
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From: "Abdul Sami" <abdul_sami_20@y...>
Subject: [access_asp] Re: Counting Query Rows in Access
: You can use a variable, having value starting from 0 and
: increment for var+1 on each row within in the while loop.
:
: --- Binu <beanz75@a...> wrote:
: > Hello-
: >
: > How can I count the number of rows in an Access query. I have
: > success
: > using the RecordCount property of the RecordSet object to count
: > the number
: > of records in a table, but it doesnt work so well for a stored
: > procedure
: > in Access.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
|
|
|
View Cart
