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
* [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
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
reco
