This method will work alright for the time being. It's actually better
than the method they use now anyway.
Thanks for all the ideas.
Ed
This looks like two different results... a SQL query returns _one_
resultset.
Try this:
SELECT CompanyName,AgentName,count(*) as ads
FROM table
Having just walked into a job a few months back, one of the tasks I've
been asked to accomplish is to counting records inside a DB based on a
field. The database in questions holds realtor listings. There are fields
for Company Name and Agent Name on each listing. What I need to do is sort
* [EMAIL PROTECTED]
Having just walked into a job a few months back, one of the tasks I've
been asked to accomplish is to counting records inside a DB based on a
field. The database in questions holds realtor listings. There are fields
for Company Name and Agent Name on each listing. What I