Solved

Access Database Query formula to help with how many times a part was shipped

Posted on 2015-02-09
1
75 Views
Last Modified: 2015-02-12
How do you setup a Access query to help take a list of part numbers with many duplicates and total how many shipments were made.  for example if the part number shows on the list 5 times that part has shipped 5 times, and the report would only show the part name once with 5 shipments.
0
Comment
Question by:cg1975
1 Comment
 
LVL 14

Accepted Solution

by:
ThomasMcA2 earned 500 total points
ID: 40599245
You need a combination of GROUP BY and COUNT, like this:

SELECT PartNumber, Count(1) as Orders
FROM Orders
WHERE ...
GROUP BY PartNumber

Open in new window


That will give a report like this:

PartNumber         Orders
ABC123               5
CDE234               2
FGH567              10

Open in new window

0

Featured Post

Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

The first two articles in this short series — Using a Criteria Form to Filter Records (http://www.experts-exchange.com/A_6069.html) and Building a Custom Filter (http://www.experts-exchange.com/A_6070.html) — discuss in some detail how a form can be…
A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.

830 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