Tech Crunch

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 Example Return the integer part of a number: SELECT Fix(756.43) AS FixNum; Definition and Usage The

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 Example Return the number of products in the “Products” table: SELECT Count(ProductID) AS NumberOfProducts FROM Products;

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 Example Return the average value for the “Price” column in the “Products” table: SELECT Avg(Price) AS

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 Example Return the absolute value of a number: SELECT Abs(-243.5) AS AbsNum; Definition and Usage The

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 Example Remove leading and trailing spaces from a string: SELECT Trim(”    SQL Tutorial    “) AS TrimmedString;