By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,487 Members | 1,735 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,487 IT Pros & Developers. It's quick & easy.

How to combine records from Excel into totals in Access?

P: 1
How do I go from:

Client AAA 7 widgets
Client AAA 3 widgets
Client AAA 4 widgets
Client BBB 5 widgets
Client BBB 4 widgets

in Excel to:

Client AAA 14 widgets
Client BBB 9 widgets

in Access?


Any help = greatly appreciated!
Dec 3 '11 #1
Share this Question
Share on Google+
1 Reply


ADezii
Expert 5K+
P: 8,679
  1. Assuming that you have a Spreadsheet that looks like:
    Expand|Select|Wrap|Line Numbers
    1. Name    Amount
    2. AAA       7
    3. AAA       3
    4. AAA       4
    5. BBB       5
    6. BBB       4
    7.  
  2. Link to the Excel Spreadsheet, and assuming you Name the Link Sheet1, execute bthe following Query:
    Expand|Select|Wrap|Line Numbers
    1. SELECT Sheet1.Name, Sum(Sheet1.Amount) AS [Total Widgets]
    2. FROM Sheet1
    3. GROUP BY Sheet1.Name;
    4.  
  3. the results will now be:
    Expand|Select|Wrap|Line Numbers
    1. Name    Total Widgets
    2. AAA          14
    3. BBB           9
Dec 3 '11 #2

Post your reply

Sign in to post your reply or Sign up for a free account.