Missing Months: Show All Months for a Yearly Sales Report in Microsoft Access Even if Missing Sales

In this video, I'm going to show you how to take a year end sales query and show data for every month of the year. If a particular month had no sales, it will show a zero instead of being missing.

Zul from YouTube (a Silver Member) asks: I just finished watching your Year End Sales Report video that shows how to make an aggregate query to total sales by month. I have some months that don't have any sales at all, and the query doesn't show them. How can I show ALL of the months and just put a ZERO where there are no sales?

Silver Members and up get access to an Extended Cut of this video. Members will learn how to drill down even more and show sales by day. We'll use a different technique. Instead of making a table with all of the days of the month (which would be tough because different months have different numbers of days) we're going to use a Recordset to loop through the days of the specified month and fill in a temporary table with all of the needed data for that period.

MEMBERS VIDEO:

BECOME A MEMBER:

LEARN MORE:

LINKS:

COURSES:

FREE TEMPLATE DOWNLOADS:

ADDITIONAL RESOURCES:

KEYWORDS:
microsoft access, ms access, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #instruction, #learn, #lesson, #training, #database, sales report missing months, missing days, show all months, all periods, recordset, temporary table, make table query, month name, month abbreviation, monthname function, format function, currency

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

[learningfromYT]

Thanks! Not sure why I spent two days trying to figure this out instead of coming straight to your channel....

[KamayoAko]

Great video.. very helpful tips... thank you for sharing.

[ritan]

Hi, Do you have a video on running totals with outer join for the missing months. Please share the link if you do. Would be great if you can help me with this. Thanks !

[ZulNorizan]

Haha thank you Richard, your videos help me a lot. Thanks for answering my question.