Hello all,

I am creating a website for some realtors to list their properties and on the front page I would like to show the "top listers" (the Realtors who have the most properties listed). My question is, how can I count the number of records that each realtor has in the listings table, and then show the top 10 listers.

Any help is very much appreciated.

Thanks in advance.

Use your database to do that.... set up a querry to show count of records... set up a querry to filter the record by the realatory and then use count(variable name).

Wm. Kent Steelman

Thanks a1adiver, Worked great.