Throwback Thursday: July 17, 2025
In today's edition of Throwback Thursday, we explore several techniques for looping and grouping by month in Access and SQL Server.
With over a million words scattered across more than 1,500 articles on this blog, you've probably missed a few things here.
That’s why each week in "Throwback Thursday," we’ll revisit some standout posts. Expect a blend of my personal favorites, insightful articles from other great minds, and a touch of coding humor to keep things light.
Highlights from NoLongerSet.com
Sticky Wicket: Looping by Month
Some programming problems are difficult to solve. Others are difficult to solve clearly.
Mike Wolfe
Looping by Month: DateSerial
The first approach to looping by month uses only the builtin VBA functions DateSerial() and DateDiff().
Mike Wolfe
Looping by Month: Custom Functions
By using a couple of custom functions, we can write very readable loops that iterate one month at a time.
Mike Wolfe
Creating a Monthly Lookup Table
Having a table where each record represents a single month can come in quite handy. Let’s create such a table.
Mike Wolfe
Wisdom from Around the Web
Brent Ozar: Date Table Fan
Brent Ozar, legendary SQL Server guru, makes his case for using a “Date Table.” The video is all done in T-SQL, but the concepts apply equally to ACE backends.
Mike Wolfe
Developer Humor
seriously
by u/acchnAsquare in ProgrammerHumor
Cover image generated by Ideogram
