troubleshooting Question

Help formatting a report

Avatar of HOTWATT
HOTWATTFlag for United States of America asked on
Microsoft Access
3 Comments1 Solution129 ViewsLast Modified:
I have a query (attached) that shows a part number and how many of that part # we shipped. I narrowed the query down to the last two years. I created a report (attached) and it is fine. But now I want to create a less detailed report that just shows each part #, # of shipments 2015, Total quantity shipped 2015 , # of shipments 2016,  Total quantity shipped 2016
 
 I am having trouble figuring out how to go about getting my report to look like this. Any help would be much appreciated!

Basically want it to look like this. I am using the first part # from the image of the report I attached.
Part #              # of shipments 2015   Total quantity 2015        # of shipments 2016         Total quantity  2016
AC0201010000            9                                     405                                    7                                     581
Query.PNG
query-2.PNG
report.PNG
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 1 Answer and 3 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 3 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros