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
Look inside

Every record

All 18 records · Last changed November 15, 2026 · Select a column heading to sort. Select a row to read the whole record.

Preview of Microsoft Access Numeric Functions
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.

More in Technology

HTML Colors Microsoft Access Date Functions Microsoft Access Utility Functions Microsoft Access String Functions MySQL Advanced Functions MySQL Data Types

Download a category with your pass