Display number of records in database

's Computer Specifications

There must be a simple way of displaying the number of records in your data
base IE: on a web page: the number of items currently in the database is: XX
Would appreciate how to show it!

's Computer Specifications

SELECT COUNT(*) FROM YourTable.
The above will give you the number of records in the table.

Regards Jens Peter Karlsen. Microsoft MVP - Frontpage.

On Fri, 3 Mar 2006 03:45:27 -0800, Raymondo
<(E-Mail Removed)> wrote:

>There must be a simple way of displaying the number of records in your data
>base IE: on a web page: the number of items currently in the database is: XX
>Would appreciate how to show it!

's Computer Specifications

That's what I needed! Thanks.

"Jens Peter Karlsen [FP-MVP]" wrote:

> SELECT COUNT(*) FROM YourTable.
> The above will give you the number of records in the table.
>
> Regards Jens Peter Karlsen. Microsoft MVP - Frontpage.
>
> On Fri, 3 Mar 2006 03:45:27 -0800, Raymondo
> <(E-Mail Removed)> wrote:
>
> >There must be a simple way of displaying the number of records in your data
> >base IE: on a web page: the number of items currently in the database is: XX
> >Would appreciate how to show it!
>

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Display number of records	Pyrite	Microsoft Access Forms	2	12th Sep 2008 02:16 PM
Display number of records	=?Utf-8?B?aW5nYWxsYQ==?=	Microsoft Access Form Coding	2	14th Nov 2007 02:58 PM
How to display N records from a database in some Div's? Thanks.	Shapper	Microsoft ASP .NET	3	21st Apr 2005 12:14 PM
display a certain number of records	=?Utf-8?B?d3hydWNr?=	Microsoft Access	1	28th Jan 2005 09:15 AM
How to display 3 records of a database?	Steven Spits	Microsoft ASP .NET	1	5th Jun 2004 12:46 PM