Monthly Report

G

Guest

I'mn trying to create a report that displays the units shipped along with gallons shipped by month for each product. The table we have from our system has the the following information in the product table: Product name, Product SKU, QUantity Shipped, Gallons, Date SHipped. I would like the heading to be the various months of the year as well a YTD total. How can this best be accomplished.
 
G

Guest

Create a query by clicking on the "CrossTab Query Wizard".Save this query and create a report from it using a report wizard.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

combining queries 1
Date range question 5
YTD in Report 1
multiple criteria SUMPRODUCT 1
Monthly Totals Plus YTD by Item 3
Can somebody help me with this cross tab query? 1
Can a crosstab query perform a running total? 3
Report structure 5

Top