Totalling Columns & Rows into Columns

[Nate74]

I'm affraid my confusing topic title is an indicator of how confused I am by this. I can't even understand the variables well enough to fully utilize Access Help or the Search function here...

What I have is a database hat has column headers that look something like this:
Customer_Name, Order_Date, Qty_Ord, Unit_Price, Total_Price

What I'm trying to get is a query output that will have

Customer_Name, Total Orders (in Dollars) for January, Total Orders (in Dollars) for February, Total Orders (in Dollars) for March, etc.

I've been able to set it up to SUM for one month, but not multiples.

I know I'm totally lame (for proof read any of my previous posts) but you guys totally bailed me out the other time I asked a lame question.

Thanks in advance!

 

[Rich]

Use a Totals query and GroupBy Month

 

[Nate74]

Cool, thanks Rich. Sounds like it will be simple. I've now managed to get monthly totals in one column, but is it possible to get each month into it's own column aligned with each customer?

Thanks again!

 

[KKilfoil]

If you are still working on this, research 'crosstab queries'