Counting Leads, Companies, Contacts associate to a campaign

Hi All

I want to count the number of records that are associated with a campaign in Microsoft CRM 4.0.

I am using Jet connected to the CRM SQL DB.

The way that CRM manages the members of the campaign is a little odd, using pointers etc and I'm struggling to find the correct path.

The Campaign has marketing lists attached to it. Each marketing list includes a data set.

The Count should be simple e.g. Count Accounts where they are in X marketing list which is part of Y Campaign. The only problem is that CRM uses activity pointers and lists to manage the links between the three parts.

I wonder if anyone has done this before.

Thanks

Dave