AboutScottgem Expertise I can answer some questions on a wide variety of business applications, including MS Office, Lotus Smartsuite, Visio, Notes and many others.
Experience I have over 16 years of experience as an IT professional, supporting a wide variety of business applications.
Scott,
I send out an eNewsletter for my business and track what links my subscribers are clicking on by using a bulk e-mail vendor. I'm building a database in Access that would neatly sum up each subscriber's "history."
I have our subscribers' profiles in one table and the past links they've clicked on in another. Is there a way to run a query that will combine all of the duplicate profile info, sum total clicks, and ACCUMULATE all of the unique info (links & months). Please see attached image; I've used Excel to illustrate my thoughts. If this isn't possible, is there any other way you recommend I attack this task? Thanks for your help!
Sincerely,
Ty
Answer I'm not clear on what is duplicated. The links or what?
What you have is a classic relational setup with a one to many relationship. You create a query that joins the two tables on your subscriberID. You then use the report wizard to create a report that groups on subscriber and lists the links they've followed in the detail section.
Hope this helps,
Scott<>
Microsoft Access MVP 2007
Author: Microsoft Office Access 2007 VBA
)