We help IT Professionals succeed at work.

Help formatting a report

HOTWATT
HOTWATT asked
on
126 Views
Last Modified: 2018-01-17
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
Comment
Watch Question

CERTIFIED EXPERT
Top Expert 2016
Commented:
This problem has been solved!
(Unlock this solution with a 7-day Free Trial)
UNLOCK SOLUTION
Hamed NasrRetired IT Professional
CERTIFIED EXPERT

Commented:
Upload a database recreating the issue.

Author

Commented:
Thanks for all the help!