MS Access Numeric Functions
Technology 18 records updated 2026-07-17
MS Access Numeric Functions, with function, and description.
Get this data
GET https://mysafeinfo.com/api/data/msaccessnumericfunctions
Sort, page, randomize, and download with query parameters; see the documentation.
Try it live
Run a request against msaccessnumericfunctions straight from your browser. Add your API key
to lift the row cap and return every record. The call goes to the API and nothing is stored here.
Preview
First 18 of 18 records. Click a column to sort these rows.
| ID | Function | Description |
|---|---|---|
| 1 | Abs | Returns the absolute value of a number |
| 2 | Atn | Returns the arc tangent of a number |
| 3 | Avg | Returns the average value of an expression |
| 4 | Cos | Returns the cosine of an angle |
| 5 | Count | Returns the number of records returned by a select query |
| 6 | Exp | Returns e raised to the power of a specified number |
| 7 | Fix | Returns the integer part of a number |
| 8 | Format | Formats a numeric value with the specified format |
| 9 | Int | Returns the integer part of a number |
| 10 | Max | Returns the maximum value in a set of values |
| 11 | Min | Returns the minimum value in a set of values |
| 12 | Randomize | Initializes the random number generator (used by Rnd()) with a seed |
| 13 | Rnd | Returns a random number |
| 14 | Round | Rounds a number to a specified number of decimal places |
| 15 | Sgn | Returns the sign of a number |
| 16 | Sqr | Returns the square root of a number |
| 17 | Sum | Calculates the sum of a set of values |
| 18 | Val | Reads a string and returns the numbers found in the string |
Notes
- Last updated on July 17, 2026.