?
Solved

find sum of field and no duplicate records in another field

Posted on 2011-04-19
2
Medium Priority
?
305 Views
Last Modified: 2012-05-11
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
0
Comment
Question by:davetough
2 Comments
 
LVL 13

Accepted Solution

by:
Lucas earned 2000 total points
ID: 35425825
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
 

Author Comment

by:davetough
ID: 35426204
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

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Access custom database properties are useful for storing miscellaneous bits of information in a format that persists through database closing and reopening.  This article shows how to create and use them.
This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…
Suggested Courses

850 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