MS Access Functions

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

MS Numeric функции за достъп

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

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

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

Функции за информация за достъп до MS

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