MS Access
- MS Access Cast
- MS Access Math
- MS Access Trigonometry
- ascii
Returns the ascii code value of the leftmost character of "string_expression". - ceiling
Returns the smallest integer greater than or equal to "numeric_expression". - chr
Returns the character that has the ASCII code value specified by "integer_expression". "Integer_expression" should be between 0 and 255. - concat
Returns a string that is the result of concatenating, or joining, "string_expression1" to "string_expression2". - curdate
Returns a date value representing the current date of the computer that the database software runs on. - curtime
Returns a time value representing the current time of the computer that the database software runs on. - dayname
Returns a character string containing the data source-specific name of the day (for example, Sunday through Saturday or Sun. through Sat. for an English data source, or Sonntag through Samstag for a German data source) for the day portion of "date_expression". - dayofmonth
Returns the day of the month (1-31) from "date_expression". Returns the days field (a signed integer) from "interval_expression". - dayofweek
Returns the day of the week in "date_expression" as an integer (1-7), where 1 represents Monday. - dayofyear
Returns the day of the year in "date_expression" as an integer (1-366). - hour
Returns the hour from "time_expression" as an integer from 0 (midnight) to 23 (11:00 pm). - instr
Searches "string_expression1" for the first occurrence of "string_expression2" and returns an integer specifying the position of "string_expression2". "Integer_expression1" sets the starting position for the search. If "integer_expression1" is omitted, the search begins at the first character position of "string_expression1". "Integer_expression2" specifies the type of string comparison. "Integer_expression1" is required if "integer_expression2" is specified. - lcase
Returns "string_expression" with all uppercase characters converted to lowercase. - left
Returns the leftmost "integer_expression" characters of "string_expression". - length
Returns the number of characters in "string_expression", excluding trailing blanks and the string termination character. - locate
Returns the starting position of the first occurrence of "string_expression1" within "string_expression2". The search starts at position "integer_expression" of "string_expression2". The first character in a string is at position 1. If "string_expression1" is not found, then zero is returned. - ltrim
Returns "string_expression" with leading spaces removed. - minute
Returns the minute (an integer from 0-59) from "time_expression". - month
Returns the month (an integer from 1-12) from "date_expression". - monthname
Returns a character string containing the data source-specific name of the month (for example, January through December or Jan. through Dec. for an English data source, or Januar through Dezember for a German data source) for the month portion of "date_expression". - now
Returns a datetime value representing the current date and time of the computer that the database software runs on. - position
Returns the starting position of "string_expression1" in "string_expression2". The first character in a string is at position 1. - quarter
Returns the quarter in "date_expression" as a number (1-4), where 1 represents January 1 through March 31. - right
Returns the rightmost "integer_expression" characters of "string_expression". - round
Returns "numeric_expression" rounded to the nearest value "integer_expression" places right of the decimal point. If "integer_expression" is negative, "numeric_expression" is rounded to the nearest absolute value "integer_expression" places to the left of the decimal point. Rounding takes place before data formatting is applied. - rtrim
Returns "string_expression" with trailing spaces removed. - sign
Returns an indicator of the sign of "numeric_expression", +1 if positive, 0 if zero, or -1 if negative. - space
Returns a string consisting of "integer_expression" spaces. - substr
Returns the substring of "string_expression" that starts at position "integer_expression1" for "integer_expression2" characters. The first character in "string_expression" is at position 1. - substring
Returns the substring of "string_expression" that starts at position "integer_expression1" for "integer_expression2" characters. The first character in "string_expression" is at position 1. - truncate
Returns "string_expression" with trailing spaces removed. - ucase
Returns "string_expression" with all lowercase characters converted to uppercase. - week
Returns the week of the year in "date_expression" as an integer value (1-53), where 1 represents the first week of the year. - year
Returns the year from "date_expression".
Parent topic: Using the expression editor