AllExperts > Business Software 
Search      
Business Software
Volunteer
Answers to thousands of questions
 Home · More Business Software Questions · Answer Library  · Encyclopedia ·
More Business Software Answers
Question Library

Ask a question about Business Software
Volunteer
Experts of the Month
Expert Login

Awards

About Us
Tell friends
Link to Us
Disclaimer

 
 
 
 
About Scottgem
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.

 
   

You are here:  Experts > Computing/Technology > Business Software > Business Software > Microsoft Access Find Duplicates Query

Business Software - Microsoft Access Find Duplicates Query


Expert: Scottgem - 10/28/2008

Question
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

Add to this Answer   Ask a Question


 
User Agreement | Privacy Policy | Kids' Privacy Policy | Help
Copyright  © 2008 About, Inc. AllExperts, AllExperts.com, and About.com are registered trademarks of About, Inc. All rights reserved.