Show All Months in Query 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?

Members

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.

•  Extended Cut Video - Silver
•  Gold Member Template Download - Gold

Silver Members and up get access to view Extended Cut videos, when available. Gold Members can download the database template from class plus get access to the Code Vault. If you signed up on YouTube you have to register on my YouTube Find User page so I can set up your account here on my web site. If you're not a member, Join Today!

Links

• Year End Sales Report: https://599cd.com/YearEnd
• Aggregate Query: https://599cd.com/Aggregate
• Outer Joins: https://599cd.com/OuterJoin
• Recordsets: https://599cd.com/Recordsets
• Access Developer 16: https://599cd.com/ACD16

Learn More FREE Access Beginner Level 1 Access Level 2 for $1.00 Free Templates TechHelp Free Templates Blank Template Contact Management Order Entry & Invoicing More Access Templates

Resources Mailing List - Get emails when new videos released Consulting - Need help with your database Tip Jar - Your tips are graciously accepted Questions? Please feel free to post your questions or comments below or post them in the Forums.

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