Group Sales By Month in a Microsoft Access Aggregate Query, Display Month Name, Sum Sales by Month

Learn how to display sales by month using an aggregate query in Microsoft Access.

Carl from El Paso, TX (a Gold member) asks: I have all of my orders with their totals calculated in a query. How can I show the total for each month of the year?

BONUS FOR CHANNEL MEMBERS:
Silver Members and up get access to an EXTENDED CUT of this video which covers additional examples. That video will show you how to show the month name (January, February, etc.), filter the records to show only a single year which we will get from a parameter and then from a form, create buttons to change the year, and then learn about field name aliases.

MEMBERS ONLY VIDEO:

BECOME A MEMBER:

LINKS:

ADDITIONAL RESOURCES:

KEYWORDS:
microsoft access, ms access, #msaccess, #microsoftaccess, sales by month, group by month, aggregate query, display month name, sum of sales, sum of order total, parameter, criteria from form field, aliases

QUESTIONS:
Please feel free to post your questions or comments below. Thanks.

[Jojosmith]

You're so FUNNY...always asking us to "Go watch that youtube"....the entire night, I keep going from one to the other of yours until my eyes can't open any more. Your lessons are always straight forward, logical, easy to understand, time saving. Your voice is clear, loud....Thank you Richard for educating the world. Without you, I can't imagine how I could manage my job easier. I am glad that I find the BEST INSTRUCTOR for all the computer courses.

[kensimba]

Such a timely tech help video coz this is where I was stuck in creating a program for a restaurant. Thanku so much instructor Richard Rost

[jenniferarnow]

Thank you for this video! I've been struggling through an AIS class that doesn't give nearly enough guidance on creating queries. 5 minutes of your video ended an hour of me trying to figure this out, because I could get the dates sorted, but it was returning crazy totals.

[andrewbenyeogor]

nice video ...really helped me for my assignment, thanks for sharing and more content like this

[GGLitcHH]

Can you explain how to find the sum for a period? for instance, I want to find sales sum for january-march but i can't figure out how to make that happen

[TGTube-lscm]

Ethiopian Calender is so different how can I create and use Ethiopian Calender

[ZulNorizan]

Hi Richard, i am currently developing a pretty similar database like this. The query im going to design are similar like this, just the query are going to be assign to a chart.

My problem is, my sales sometimes isnt consistent. There is a month where there are no sales at all, but i want that month to be listed also, and the sales amount will be zero (or null value, doesnt matter)

How can i do this?

[jaliyaranaweera]

how to get the sum of a grouped report based on fee avoiding duplicate records

[alexiabain]

I dont get it, exact same steps and I get different results

[Excelandaccessusefultips]

Sir
I have been following up on all your lectures super great and nice as I have learned a lot from you
But I have a problem in creating my database which in excel it easy and I want to know how to do it on access..

Can you send me your email
So I can send a screenshot to you

Please help