Database counter

[PMC]

Hi,

Probably answered many times, but here it is.
I have an simple Access database. I would like to display the number of
records found in the database and display it on the result page.
So, a text that says: "Search results xx records"
Can I do that with a separate results table and a custom SOL, or do I need
to study more in Jim Buyens excellent books?

Your help is appreciated.

Peter Mulder (NL)


---------------------------------------------------------------------
"Are you still wasting your time with spam?...
There is a solution!"

Protected by GIANT Company's Spam Inspector
The most powerful anti-spam software available.
http://mail.spaminspector.com

 

[MD WebsUnlimited.com]

Hi Peter,

You can use SQL and the aggregate verb count.

SELECT Count([SKU]) AS [JBP-04 Purchased]
FROM product_orders
WHERE (((product_orders.SKU)="JBP-04"));

 

[PMC]

Thanks Mike, that worked.

Peter

Hi Peter,

You can use SQL and the aggregate verb count.

SELECT Count([SKU]) AS [JBP-04 Purchased]
FROM product_orders
WHERE (((product_orders.SKU)="JBP-04"));


--
Mike -- FrontPage MVP '97-'02
http://www.websunlimited.com
FrontPage Add-ins Since '97 2003 / 2002 / 2000 Compatible
-------------------------------------------------------------------------- --
--------------------
If you think I'm doing a good job, let MS know at (e-mail address removed)

Hi,

Probably answered many times, but here it is.
I have an simple Access database. I would like to display the number of
records found in the database and display it on the result page.
So, a text that says: "Search results xx records"
Can I do that with a separate results table and a custom SOL, or do I need
to study more in Jim Buyens excellent books?

Your help is appreciated.

Peter Mulder (NL)


---------------------------------------------------------------------
"Are you still wasting your time with spam?...
There is a solution!"

Protected by GIANT Company's Spam Inspector
The most powerful anti-spam software available.
http://mail.spaminspector.com