Display number of records in database

[Raymondo]

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!

 

[Jens Peter Karlsen [FP-MVP]]

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

Regards Jens Peter Karlsen. Microsoft MVP - Frontpage.

 

[Raymondo]

That's what I needed! Thanks.

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

Regards Jens Peter Karlsen. Microsoft MVP - Frontpage.