MS Access Format() Function Example Format a numeric expression to percent: SELECT Format(0.5, “Percent”) AS FormattedNum; Definition and Usage The
MS Access Fix() Function
MS Access Fix() Function Example Return the integer part of a number: SELECT Fix(756.43) AS FixNum; Definition and Usage The
MS Access Exp() Function
MS Access Exp() Function Example Return e raised to the 5th power: SELECT Exp(5) AS ExpNum; Definition and Usage The
MS Access Count() Function
MS Access Count() Function Example Return the number of products in the “Products” table: SELECT Count(ProductID) AS NumberOfProducts FROM Products;
MS Access Cos() Function
MS Access Cos() Function Example Return the cosine of an angle: SELECT Cos(5) AS CosNum; Definition and Usage The Cos()
MS Access Avg() Function
MS Access Avg() Function Example Return the average value for the “Price” column in the “Products” table: SELECT Avg(Price) AS
MS Access Atn() Function
MS Access Atn() Function Example Return the arc tangent of a number: SELECT Atn(5) AS AtnNum; Definition and Usage The
MS Access Abs() Function
MS Access Abs() Function Example Return the absolute value of a number: SELECT Abs(-243.5) AS AbsNum; Definition and Usage The
MS Access UCase() Function
MS Access UCase() Function Example Convert the text in “CustomerName” to upper-case: SELECT UCASE(CustomerName) AS UppercaseCustomerName FROM Customers; Definition and
MS Access Trim() Function
MS Access Trim() Function Example Remove leading and trailing spaces from a string: SELECT Trim(” SQL Tutorial “) AS TrimmedString;