MS Access Functions

MS Access има много вградени функции. Тази справка съдържа низов, цифров, дата и информационни функции в MS Access.

Функции за низ на достъп до MS Access

Function	Описание
Asc	Returns the number code that represents the specific character
Chr	Returns the character based on the number code
Concat with &	Concatenates multiple strings together into a single string with the & operator
CurDir	Returns the current path
Format	Formats a string expression
InStr	Returns the position of the first occurrence of a string in another string
InstrRev	Returns the position of the first occurrence of a string in another string, starting from the end of the string
LCase	Converts a string to lower-case
Left	Extracts a substring from a string (starting from left)
Len	Returns the length of the specified string
LTrim	Removes leading spaces from a string
Mid	Extracts a substring from a string (starting at any position)
Replace	Replaces a sequence of characters in a string with another set of characters (a number of times)
Right	Extracts a substring from a string (starting from right)
RTrim	Removes trailing spaces from a string
Space	Returns a string with a specified number of spaces
Split	Splits a string into substrings (based on a delimiter) and returns the result as an array of substrings
Str	Returns a string representation of a number
StrComp	Returns an integer value representing the result of a string comparison
StrConv	Returns a converted string
StrReverse	Returns a string whose characters are in reverse order
Trim	Removes leading and trailing spaces from a string
UCase	Converts a string to upper-case

Function	Описание
Abs	Returns the absolute value of a number
Atn	Returns the arctangent of a number
Avg	Returns the average value of an expression
Cos	Returns the cosine of an angle
Count	Returns the number of records in a select query
Exp	Returns e raised to the nth power
Fix	Returns the integer portion of a number
Format	Takes a numeric expression and returns it as a formatted string
Int	Returns the integer portion of a number
Max	Returns the maximum value of an expression
Min	Returns the minimum value of an expression
Randomize	Allows you to change the seed value used by the random number generator for the Rnd() function
Rnd	Generates a random number
Round	Returns a number rounded to a certain number of decimal places
Sgn	Returns the sign of a number
Sqr	Returns the square root of a number
Sum	Returns the summed value of an expression
Val	Accepts a string as input and returns the numbers found in that string

Function	Описание
CurrentUser	Returns the name of the current Access user
Environ	Returns the value of an operating system environment variable
IsDate	Returns TRUE if the expression is a valid date, otherwise FALSE
IsNull	Returns TRUE if the expression is a null value, otherwise FALSE
IsNumeric	Returns TRUE if the expression is a valid number, otherwise FALSE

Function	Описание
CurrentUser	Returns the name of the current Access user
Environ	Returns the value of an operating system environment variable
IsDate	Returns TRUE if the expression is a valid date, otherwise FALSE
IsNull	Returns TRUE if the expression is a null value, otherwise FALSE
IsNumeric	Returns TRUE if the expression is a valid number, otherwise FALSE