DRW Question

[CJ]

I want the database results wizard in FP2003 to tell me how many records
match a certain criteria. For example on page
http://www.mymea.co.uk/search.htm I have 3 links to search results pages
that work on Queries built into the Access database.

What I want to do is put in brackets after each link the number of
properties that exist in those categories. I guess I would have to save
search.htm as an ASP file first then try and build in some sort of COUNT
function..? Is this possible?

Many thanks.

 

[Jon]

Hi,
you'd need to make your search page an asp page with a query along the lines
of
select categoryname, count(*) As categorycount
from tablename
group by categoryname

Jon
Microsoft MVP - FP

 

[CJ]

Hi,
you'd need to make your search page an asp page with a query along the lines
of
select categoryname, count(*) As categorycount
from tablename
group by categoryname

Jon
Microsoft MVP - FP

Many thanks. Had problems including 3 custom queries in the same database
results, so ended up going through the wizard 3 times! See
http://www.mymea.co.uk/search.asp

CJ