MS Access Numeric Functions

Showing 10 of 18 records (Sample Data)

Function Description
Abs Returns the absolute value of a number
Atn Returns the arc tangent of a number
Avg Returns the average value of an expression
Cos Returns the cosine of an angle
Count Returns the number of records returned by a select query
Exp Returns e raised to the power of a specified number
Fix Returns the integer part of a number
Format Formats a numeric value with the specified format
Int Returns the integer part of a number
Max Returns the maximum value in a set of values

Notes

  • Last updated on January 27, 2020