Category: MS Access Functions

Last updated: August 26, 2026. The StrConv function converts a string using a specified case, width, or character-set option. Syntax…

Last updated: August 26, 2026. The Right function returns a requested number of characters from the end of a string.…

Last updated: August 26, 2026. The Min aggregate returns the smallest non-Null value in a query group. Syntax Argument Description…

Last updated: August 26, 2026. The Max aggregate returns the largest non-Null value in a query group. Syntax Argument Description…

Last updated: August 26, 2026. The IsNumeric function reports whether an expression can be evaluated as a number. Syntax Argument…

Last updated: August 26, 2026. The IsDate function returns True when an expression can be recognized as a date or…

Last updated: August 26, 2026. The CurDir function returns the current path for the default drive or for a specified…

Last updated: August 25, 2026. The Access Choose function selects one value from a list using a 1-based numeric index.…

Last updated: August 26, 2026. The Last aggregate returns a value from the last record encountered by the query engine.…

Last updated: August 27, 2026. A query result is a table-shaped set of rows and columns produced by a SQL…