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

JSON XML CSV Download CSV

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