Shipping by Month

[NateSmith]

Hi Everyone,

I'm trying to write a basic query. I haven't done this in a few years so I seem to have forgot most of what I once knew.

For each month of the year, I want to have two columns. 1) What how many units of a product were ordered and B) how many units of that product they shipped.

On the left most column, I will have all of the item numbers.

I know how to do it with one month--I just group by item number and sum. However, if I go to add another month in the query, I need to link the two tables (I have a table for each month).

How would I go about having two columns per month for all items?

Thanks!

[burrina]

You should ONLY have One table for Months. In your Products table you need a MonthID Number field and then link the Products table to the Months table.
Are you trying to have Multiple Months in the same query? Below is code for Current Month

Format(DateSerial(Year(Date()),Month(Date()),Day(D ate())),"mmmm ")

[ItsMe]

What does it mean to have a table for each month?