Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2009
    Posts
    10

    Unanswered: MS Access Calculation

    Hi,
    I have an Access database 2003 for product, orders and customer information.
    I've joined them to determine the most sold product.


    The results of my query looks like this:-
    ProductID NumberOrdered
    3001............ 2
    7958............ 3
    3001............ 1
    3001............ 3


    Now I desire to achieve the following:-
    Be able to take the result of this query and have it NOW look like this:-

    ProductID NumberOrdered
    3001 ............ 6
    7958 ............ 3

    I tried the Totals (Sum/GroupBy/Count) but it changes all my product Ids to 1.
    The other results of my trying just don't produce what I desire to achieve.

    Any help rendered would be greatly appreciated.

  2. #2
    Join Date
    May 2005
    Location
    Nevada, USA
    Posts
    2,888
    Provided Answers: 6
    Well, the totals query is the tool for the job. I can't imagine what would make it change the product ID's. What was the SQL of that query?
    Paul

  3. #3
    Join Date
    Aug 2009
    Posts
    10
    Thanks for the reply.
    It works fine now.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •