Create a Running Total in a Microsoft Access Query
Calculate a deterministic running total in Access by date and unique key, with optional partitioning by customer or account.
Category: MS Access Functions
Return the Top Records in Each Group in Microsoft Access
Return the highest-value or most recent rows for every group in Access with a correlated TOP subquery and deterministic tie handling.
Find Duplicate Records in a Microsoft Access Query
Find duplicate Access records by one field or a combination of fields and review the matching rows safely.
Create a Crosstab Query in Microsoft Access
Build a Microsoft Access crosstab query with row headings, fixed month columns, totals, date criteria, and properly declared parameters.
Calculate Age from a Birth Date in Microsoft Access
Calculate a person’s completed age in Microsoft Access with a query expression or reusable VBA function, including birthdays and leap-day decisions.
Handle Null Values with Nz and IIf in Access
Use Nz, IsNull, and IIf correctly in Microsoft Access queries, forms, and reports without confusing Null with zero or an empty string.
Group Access Query Results by Month or Year
Summarize Microsoft Access records by month or year with DateSerial, Year, Month, and aggregate functions while preserving chronological sorting.
Create a Date Range Query in Microsoft Access
Learn how to filter Microsoft Access records between two dates, include records that contain times, use parameters, and build reliable current-month criteria.
Access Year Function
Last updated: August 26, 2026. The Year function returns the four-digit year component of a date. Syntax Argument Description date…
Access WeekdayName Function
Last updated: August 26, 2026. The WeekdayName function returns the localized name of a weekday number. Syntax Argument Description weekday…