> ## Content Index
> Fetch the complete content index at: https://nolongerset.com/llms.txt
> Use this file to discover other available public pages before exploring further.

# Throwback Thursday: July 17, 2025
- URL: https://nolongerset.com/throwback-thursday-2025-07-17/
- Published: 2025-07-18T03:53:39.000Z
- Updated: 2026-05-08T12:46:20.000Z
- Description: In today's edition of Throwback Thursday, we explore several techniques for looping and grouping by month in Access and SQL Server.
- Author: Mike Wolfe
- Tags: Throwback Thursday, #Import 2026-05-20 02:59

*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 MonthSome programming problems are difficult to solve. Others are difficult to solve clearly.![](https://nolongerset.com/content/images/size/w256h256/2020/09/NLS_Icon_square.png)No Longer SetMike Wolfe![](https://nolongerset.com/content/images/2021/02/county-cricket-2639131_1920.jpg)](https://nolongerset.com/sticky-wicket-looping-by-month/)

[Looping by Month: DateSerialThe first approach to looping by month uses only the builtin VBA functions DateSerial() and DateDiff().![](https://nolongerset.com/content/images/size/w256h256/2020/09/NLS_Icon_square.png)No Longer SetMike Wolfe![](https://nolongerset.com/content/images/2021/02/agenda-1928419_1920.jpg)](https://nolongerset.com/looping-by-month-dateserial/)

[Looping by Month: Custom FunctionsBy using a couple of custom functions, we can write very readable loops that iterate one month at a time.![](https://nolongerset.com/content/images/size/w256h256/2020/09/NLS_Icon_square.png)No Longer SetMike Wolfe![](https://nolongerset.com/content/images/2021/02/calendar-3109304_1920.jpg)](https://nolongerset.com/looping-by-month-custom-functions/)

[Creating a Monthly Lookup TableHaving a table where each record represents a single month can come in quite handy. Let’s create such a table.![](https://nolongerset.com/content/images/size/w256h256/2020/09/NLS_Icon_square.png)No Longer SetMike Wolfe![](https://nolongerset.com/content/images/2021/02/calendar-5606_1920.jpg)](https://nolongerset.com/creating-a-monthly-lookup-table/)

## Wisdom from Around the Web

[Brent Ozar: Date Table FanBrent 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.![](https://nolongerset.com/content/images/size/w256h256/2020/09/NLS_Icon_square.png)No Longer SetMike Wolfe![](https://nolongerset.com/content/images/2021/03/2021-03-01-21_20_05-mjw20-Window.png)](https://nolongerset.com/brent-ozar-date-table-fan/)

## Developer Humor

> [seriously](https://www.reddit.com/r/ProgrammerHumor/comments/1lzqsdz/seriously/)  
> by [u/acchnAsquare](https://www.reddit.com/user/acchnAsquare/) in [ProgrammerHumor](https://www.reddit.com/r/ProgrammerHumor/) 

*Cover image generated by Ideogram*