7/15/25, 10:07 AM MS Access Functions
Tutorials Exercises Services Sign In
HTML
CSS JAVASCRIPT SQL PYTHON JAVA PHP HOW TO W3.CSS C
MS Access Functions
❮ Previous Next ❯
MS Access has many built-in functions.
This reference contains the string, numeric, and date functions in MS Access.
MS Access String Functions
Function Description
Asc Returns the ASCII value for the specific character
Chr Returns the character for the specified ASCII number code
Concat with & Adds two or more strings together
CurDir Returns the full path for a specified drive
Format Formats a value with the specified format
InStr Gets the position of the first occurrence of a string in another
InstrRev Gets the position of the first occurrence of a string in another,
from the end of string
LCase Converts a string to lower-case
https://www.w3schools.com/sql/sql_ref_msaccess.asp 1/7
7/15/25, 10:07 AM MS Access Functions
Left Tutorials
Extracts a number of characters
Exercises
left)
Services
from a string (starting from Sign In
HTML
CSS JAVASCRIPT SQL PYTHON JAVA PHP HOW TO W3.CSS C
Len Returns the length of a string
LTrim Removes leading spaces from a string
Mid Extracts some characters from a string (starting at any position)
Replace Replaces a substring within a string, with another substring, a
specified number of times
Right Extracts a number of characters from a string (starting from
right)
RTrim Removes trailing spaces from a string
Space Returns a string of the specified number of space characters
Split Splits a string into an array of substrings
Str Returns a number as string
StrComp Compares two strings
StrConv Returns a converted string
StrReverse Reverses a string and returns the result
Trim Removes both leading and trailing spaces from a string
UCase Converts a string to upper-case
MS Access Numeric Functions
Function Description
Abs Returns the absolute value of a number
Atn Returns the arc tangent of a number
Avg Returns the average value of an expression
https://www.w3schools.com/sql/sql_ref_msaccess.asp 2/7
7/15/25, 10:07 AM MS Access Functions
Cos Tutorials
Returns the cosine of an angle
Exercises Services Sign In
Count Returns the number of records returned by a select query
HTML
CSS JAVASCRIPT SQL PYTHON JAVA PHP HOW TO W3.CSS C
Exp Returns e raised to the power of a specified number
Fix Returns the integer part of a number
Format Formats a numeric value with the specified format
Int Returns the integer part of a number
Max Returns the maximum value in a set of values
Min Returns the minimum value in a set of values
Randomize Initializes the random number generator (used by Rnd()) with a
seed
Rnd Returns a random number
Round Rounds a number to a specified number of decimal places
Sgn Returns the sign of a number
Sqr Returns the square root of a number
Sum Calculates the sum of a set of values
Val Reads a string and returns the numbers found in the string
MS Access Date Functions
Function Description
Date Returns the current system date
DateAdd Adds a time/date interval to a date and then returns the date
DateDiff Returns the difference between two dates
DatePart Returns a specified part of a date (as an integer)
https://www.w3schools.com/sql/sql_ref_msaccess.asp 3/7
7/15/25, 10:07 AM MS Access Functions
DateSerial
Tutorials Returns a date from the specified
Exercises
values)
Services parts (year, month, and daySign In
HTML
CSS JAVASCRIPT SQL PYTHON JAVA PHP HOW TO W3.CSS C
DateValue Returns a date based on a string
Day Returns the day of the month for a given date
Format Formats a date value with the specified format
Hour Returns the hour part of a time/datetime
Minute Returns the minute part of a time/datetime
Month Returns the month part of a given date
MonthName Returns the name of the month based on a number
Now Returns the current date and time based on the computer's
system date and time
Second Returns the seconds part of a time/datetime
Time Returns the current system time
TimeSerial Returns a time from the specified parts (hour, minute, and
second value)
TimeValue Returns a time based on a string
Weekday Returns the weekday number for a given date
WeekdayName Returns the weekday name based on a number
Year Returns the year part of a given date
MS Access Some Other Functions
Function Description
CurrentUser Returns the name of the current database user
Environ Returns a string that contains the value of an operating system
environment variable
https://www.w3schools.com/sql/sql_ref_msaccess.asp 4/7
7/15/25, 10:07 AM MS Access Functions
IsDateTutorials Checks whether an expression can
Exercises Services be converted to a date Sign In
IsNull Checks whether an expression contains Null (no data)
HTML
CSS JAVASCRIPT SQL PYTHON JAVA PHP HOW TO W3.CSS C
IsNumeric Checks whether an expression is a valid number
❮ Previous Next ❯
Track your progress - it's free! Sign Up Log in
COLOR PICKER
https://www.w3schools.com/sql/sql_ref_msaccess.asp 5/7
7/15/25, 10:07 AM MS Access Functions
Tutorials Exercises Services Sign In
HTML
CSS JAVASCRIPT SQL PYTHON JAVA PHP HOW TO W3.CSS C
PLUS SPACES
GET CERTIFIED FOR TEACHERS
FOR BUSINESS CONTACT US
Top Tutorials
HTML Tutorial
CSS Tutorial
JavaScript Tutorial
How To Tutorial
SQL Tutorial
Python Tutorial
W3.CSS Tutorial
Bootstrap Tutorial
PHP Tutorial
Java Tutorial
C++ Tutorial
jQuery Tutorial
Top References
HTML Reference
CSS Reference
JavaScript Reference
SQL Reference
Python Reference
W3.CSS Reference
Bootstrap Reference
PHP Reference
HTML Colors
Java Reference
Angular Reference
jQuery Reference
Top Examples Get Certified
HTML Examples HTML Certificate
CSS Examples CSS Certificate
https://www.w3schools.com/sql/sql_ref_msaccess.asp 6/7
7/15/25, 10:07 AM MS Access Functions
JavaScript Examples JavaScript Certificate
Tutorials How To Examples
Exercises
SQL Examples
Services Front End Certificate
SQL Certificate
Sign In
Python Examples Python Certificate
HTML
CSS W3.CSS
JAVASCRIPT ExamplesSQL PYTHON JAVA PHP PHPHOW Certificate
TO W3.CSS C
Bootstrap Examples jQuery Certificate
PHP Examples Java Certificate
Java Examples C++ Certificate
XML Examples C# Certificate
jQuery Examples XML Certificate
FORUM ABOUT ACADEMY
W3Schools is optimized for learning and training. Examples might be simplified to improve
reading and learning.
Tutorials, references, and examples are constantly reviewed to avoid errors, but we cannot
warrant full correctness
of all content. While using W3Schools, you agree to have read and accepted our terms of use,
cookie and privacy policy.
Copyright 1999-2025 by Refsnes Data. All Rights Reserved. W3Schools is Powered by W3.CSS.
https://www.w3schools.com/sql/sql_ref_msaccess.asp 7/7
