Recent content by LJEsposito

I posted a reply but I'm not sure why I don't see it or why this forum times me out so quickly! To Jon K - Your code was perfect once I found out how to update VBA references in 2007 to accomodate the ADO. To mihalisp - I had suggested you try to use the Query > Totals > Group By...

The code fix in the link I had provided above did work for me so I documented my efforts there. Thanks for your advice Paul! While I liked the CrossTab query (if it would avoid VBA) I needed far more fields than I was listing in my example that would render it very cumbersome if useful at all...

Thanks for the quick Repy but that didn't work - it provided the following: Contact | Link | How Many ==================== John | Link B | 1 Larry | Link A | 2 Larry | Link C | 1 Larry | Link D | 1 Nancy | Link A | 1 Nancy | Link D | 2 But I did find another thread that may suit my needs...

We have a marketing system that monitors campaign links clicked: Contact | Link =========== Larry | Link D Nancy | Link A John | Link B Larry | Link A Larry | Link A Larry | Link C Nancy | Link D Nancy | Link D Ideally I'd like a query that summarizes as follows: Contact | Links clicked...