find sum of field and no duplicate records in another field

Posted on 2011-04-19
Last Modified: 2012-05-11
i want to run a query to sum the total of qty installed and display no duplicate item numbers.
Item Description is being typed in differently sometimes and it is causing duplicates to occur.
Is there a way to ignore the Item description field?
does not matter which variation of item description displays.
thank you
sample attached
Question by:davetough
    LVL 13

    Accepted Solution

    Then your query should be this:

    SELECT [PART TABLE].[Item Code], Sum([PART TABLE].[QTY Installed]) AS [QTY Installed]
    GROUP BY [PART TABLE].[Item Code]
    ORDER BY [PART TABLE].[Item Code];

    Open in new window


    Author Comment

    am i right- then if I want item description- I will have to join it to this data after I first run this query?
    thank you

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    In Debugging – Part 1, you learned the basics of the debugging process. You learned how to avoid bugs, as well as how to utilize the Immediate window in the debugging process. This article takes things to the next level by showing you how you can us…
    Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
    Familiarize people with the process of utilizing SQL Server views from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Access…
    In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…

    779 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    10 Experts available now in Live!

    Get 1:1 Help Now