find sum of field and no duplicate records in another field

hello,
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
duplicate.mdb
davetoughAsked:
Who is Participating?
 
LucasConnect With a Mentor MS Dynamics DeveloperCommented:
Then your query should be this:


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

Open in new window

0
 
davetoughAuthor Commented:
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
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.