How do I display the number of search results found?

M

Margot

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to display zero value in blank fields of Cross Tab query 0
How do I remove the top half of a block interval? 1
Creating a Search using a combo box and then creating a report. 4
How to display the merge function "url" of a picture? 0
AppleScript - How do I select a text ? 1
Menu driven PowerPoint presentations 0
Excel Macro VBA to Count Google Search Results 0
Unexplained failure of wdFindStop at end of search 0

Top