Technology · Reference dataset
Microsoft Access Numeric Functions
Microsoft Access numeric functions with a description, the documented syntax, the return type, a documented example with its result, and a link to the Microsoft documentation.
Download options
Every record
All 18 records · Last changed November 15, 2026 · Select a column heading to sort. Select a row to read the whole record.
| Function | Description | Syntax | Return type | Example | Result | Doc url |
|---|---|---|---|---|---|---|
| Abs | Returns the absolute value of a number | Abs(number) | Same type as the argument | Abs(50.3) | 50.3 | https://learn.microsoft.com/en-us/office/vba/language/reference/user-interface-help/abs-function |
| Atn | Returns the arc tangent of a number | Atn(number) | Double | https://learn.microsoft.com/en-us/office/vba/language/reference/user-interface-help/atn-function | ||
| Avg | Returns the average value of an expression | |||||
| Cos | Returns the cosine of an angle | Cos(number) | Double | https://learn.microsoft.com/en-us/office/vba/language/reference/user-interface-help/cos-function | ||
| Count | Returns the number of records returned by a select query | |||||
| Exp | Returns e raised to the power of a specified number | Exp(number) | Double | https://learn.microsoft.com/en-us/office/vba/language/reference/user-interface-help/exp-function | ||
| Fix | Returns the integer part of a number | Fix(number) | Fix(99.2) | 99 | https://learn.microsoft.com/en-us/office/vba/language/reference/user-interface-help/int-fix-functions | |
| Format | Formats a numeric value with the specified format | Format(Expression, [ Format ], [ FirstDayOfWeek ], [ FirstWeekOfYear ]) | Variant (String) | MyTime = #17:04:23#: Format(MyTime, "h:m:s") | "17:4:23" | https://learn.microsoft.com/en-us/office/vba/language/reference/user-interface-help/format-function-visual-basic-for-applications |
| Int | Returns the integer part of a number | Int(number) | Int(99.8) | 99 | https://learn.microsoft.com/en-us/office/vba/language/reference/user-interface-help/int-fix-functions | |
| Max | Returns the maximum value in a set of values | |||||
| Min | Returns the minimum value in a set of values | |||||
| Randomize | Initializes the random number generator (used by Rnd()) with a seed | Randomize [ number ] | https://learn.microsoft.com/en-us/office/vba/language/reference/user-interface-help/randomize-statement | |||
| Rnd | Returns a random number | Rnd [ (Number) ] | Single | Int((6 * Rnd) + 1) | https://learn.microsoft.com/en-us/office/vba/language/reference/user-interface-help/rnd-function | |
| Round | Rounds a number to a specified number of decimal places | Round(expression, [ numdecimalplaces ]) | https://learn.microsoft.com/en-us/office/vba/language/reference/user-interface-help/round-function | |||
| Sgn | Returns the sign of a number | Sgn(number) | Variant (Integer) | MyVar1 = 12: Sgn(MyVar1) | 1 | https://learn.microsoft.com/en-us/office/vba/language/reference/user-interface-help/sgn-function |
| Sqr | Returns the square root of a number | Sqr(number) | Double | Sqr(4) | 2 | https://learn.microsoft.com/en-us/office/vba/language/reference/user-interface-help/sqr-function |
| Sum | Calculates the sum of a set of values | |||||
| Val | Reads a string and returns the numbers found in the string | Val(string) | Val("2457") | 2457 | https://learn.microsoft.com/en-us/office/vba/language/reference/user-interface-help/val-function |
Open this data in a free tool: CSV to JSON · JSON formatter · SQL INSERT generator · CSV to XML
CSV / JSON / XML
Put this data to work.
All 18 records are available without a pass, within the free request limits.
- CSV for spreadsheets and lookup tables
- JSON for apps and data analysis
- XML for imports and integrations
Choose your file
Your key is used for this request and is not saved by this page.
Commercial use is allowed, free or paid.
Downloaded a CSV? Convert CSV to JSON, generate SQL inserts, remove duplicate lines, or sort a list with the free tools.
Scope and sources
Last checked against sources: October 15, 2026.
Last changed: November 15, 2026. This is when we last changed the data or its description. It doesn’t mean the data runs up to that date.
Microsoft Access Numeric Functions has 18 records and 7 fields: Function, Description, Syntax, Return type, Example, Result, Doc url.
A complete download includes all 18 records currently held in this dataset. Check the description and sources to decide whether its scope fits your project.
Use this dataset through the API
GET https://mysafeinfo.com/api/data/msaccessnumericfunctions
Choose a format, sort, or request fewer rows. A pass key gives access to the complete dataset. See the examples and parameters.