MS Access Functions

MS Access String Functions

Microsoft Access includes numerous built-in functions, encompassing string, numeric, and date operations within its functionality.

Function	Description
Asc	Retrieve the ASCII value for the specific character
Chr	Retrieve the character for the specified ASCII number code
Concat with &	Concatenates two or more strings.
CurDir	Provides the complete file path for a specified drive.
Format	Applies a specified format to a value.
InStr	Determines the position of the first occurrence of a string within another string.
InstrRev	Gets the position of the last occurrence of a string within another string.
LCase	Changes a string to lowercase.
Left	Retrieves a specified number of characters from the left side of a string.
Len	Provides the number of characters in a string.
LTrim	Eliminates leading spaces from a string.
Mild	Retrieves characters from a string, starting from any specified position.
Replace	Substitutes a substring within a string with another substring, limited to a specified number of occurrences.
Right	Retrieves a specified number of characters from the right side of a string.
RTrim	Eliminates trailing spaces from the end of a string.
Space	Generates a string consisting of a specified number of space characters.
Split	Divides a string into an array of substrings.
Str	Converts a number to a string.
StrComp	Evaluates and compares two strings.
Strconv	Produces a converted string.
StrReverse	Reverses a string and returns the reversed version.
Trim	Eliminates both leading and trailing spaces from a string.
UCase	Changes a string to uppercase.

Function	Description
Abs	Provides the absolute value of a number.
Atn	Calculates and returns the arctangent of a number.
Avg	Calculates the average value of an expression.
Cos	Calculates the cosine of an angle.
Count	Returns the count of records retrieved by a SELECT query.
Exp	Calculates the value of Euler’s number raised to a specified power.
Fix	Returns the integer portion of a number.
Format	Applies a specified format to a numeric value.
Int	Returns the whole number part of a numeric value
Max	Returns the highest value from a given set of values
Min	Returns the lowest value from a given set of values
Randomize	Sets the seed value for the random number generator used by Rnd().
Rnd	Generates a random number.
Round	Rounds a number to a specified decimal precision
Sgn	Returns the mathematical sign of a number
Sqr	Calculates the square root of a number.
Sum	Computes the total sum of a series of values
Val	Extracts numerical values from a string and returns them.

Function	Description
Date	Returns the current system date and time.
DateADD	Adds a specified time or date interval to a given date and returns the resulting date.
DateDiff	Calculates the duration or difference between two dates.
DatePart	Retrieves a specific segment of a date, returned as an integer.
DateSerial	Constructs and returns a date from provided year, month, and day values.
DateValue	Converts a string into a date value.
Day	Retrieves the day of the month from a specified date.
Format	Applies a specified format to a date value.
Hour	Retrieves the hour component from a time or datetime value.
Minute	Retrieves the minute component from a time or datetime value.
Month	Retrieves the month component from a specified date.
MonthName	Returns the name of the month corresponding to a given month number.
Now	Returns the current date and time based on the system clock of the computer.
Second	Retrieves the seconds component from a time or datetime value.
Time	Returns the current time based on the system clock.
TimeSerial	Constructs and returns a time from provided hour, minute, and second values.
TimeValue	Converts a string into a time value.
Weekday	Returns the weekday number (1 for Sunday through 7 for Saturday) corresponding to a given date.
WeekdayName	Returns the name of the weekday corresponding to a given weekday number.
Year	Retrieves the year component from a specified date.

Function	Description
CurrentUser	Retrieve the username currently logged into the database.
Environ	Returns a string representing the value of an operating system environment variable.
IsDate	Verifies if an expression can be converted into a valid date format.
IsNull	Checks if an expression contains a null value (no data).
IsNumeric	Checks if an expression is a valid numeric value.