Solved

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

Posted on 2015-02-09
1
74 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

Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

Question has a verified solution.

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

I originally created this report in Crystal Reports 2008 where there is an option to underlay sections. I initially came across the problem in Access Reports where I was unable to run my border lines down through the entire page as I was using the P…
As tax season makes its return, so does the increase in cyber crime and tax refund phishing that comes with it
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
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.

776 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