|
||||||
|
Missing Months By Richard Rost ![]() ![]() ![]() 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? MembersMembers 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.
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
Keywordsmicrosoft 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
|
||||
Check out these other pages that may be of interest to you: |
|
| |||