Link to home
Avatar of HOTWATT
HOTWATTFlag for United States of America

asked on

Help formatting a report

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
Avatar of Rey Obrero (Capricorn1)
Rey Obrero (Capricorn1)
Flag of United States of America image

Blurred text
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
Upload a database recreating the issue.
Avatar of HOTWATT

ASKER

Thanks for all the help!