How do I display the number of search results found?

I have a webpage with a search form and another webpage which displays the
search results (I made it with help of the DBRW). On this 2nd web page I
would also like to display the number of search results found. Can anyone
tell me how to do this?

I already tried with the 'SELECT COUNT(*) FROM table' statement. However as
soon as I add a WHERE-clause I get a 'Database Results Wizard Error'.

Can anyone tell me what I do wrong with respect to the 'SELECT
COUNT(*)'-statement? Or how I can do it without 'SELECT COUNT(*)'?

Any help is appreciated. Thanks,
Margot

(using FP2003 and Access)