Recent content by MoreInterestingThanW

Thanks - but I think it has to be code Thanks Moniker Unfortunately the Calls table does not have any count of calls so each company is associated with a list of calls of indeterminate length with calls identified by autonumbered CallID numbers. So I think it has to be code... I now have some...

I have a database with company records in one table and calls made to companies in another table; the two tables properly related on a CompanyID field. A query joining the tables returns a dataset with multiple instances of CompanyID's because each company may have received 0 - n calls. I...