This article contains links to articles that provide details about common functions used in expressions in Microsoft Access. They are arranged first by group and then are arranged alphabetically at the end of this article.
Tip: Beginning with Access 2010, the Expression Builder has IntelliSense, so you can see what arguments your expression requires.
ActiveX
Application
Arrays
Array Function
Filter Function
Join Function
LBound Function
Split Function
UBound Function
Conversion
Asc Function
Chr Function
EuroConvert Function
FormatCurrency Function
FormatDateTime Function
FormatNumber Function
FormatPercent Function
GUIDFromString Function
Hex Function
Nz Function
Oct Function
Str Function
StringFromGUID Function
Type Conversion Functions
Val Function
Database
DDE Function
DDEInitiate Function
DDERequest Function
DDESend Function
Eval Function
Partition Function
Date/Time
Date Function
DateAdd Function
DateDiff Function
DatePart Function
DateSerial Function
DateValue Function
Day Function
Hour Function
Minute Function
Month Function
MonthName Function
Now Function
Second Function
Time Function
Timer Function
TimeSerial Function
TimeValue Function
Weekday Function
WeekdayName Function
Year Function
Domain Aggregate
DAvg Function
DCount Function
DFirst, DLast Functions
DLookup Function
DMin, DMax Functions
DStDev, DStDevP Functions
DSum Function
DVar, DVarP Functions
Error Handling
File Input/Output
EOF Function
FreeFile Function
Input Function
Loc Function
LOF Function
Seek Function
File Management
CurDir Function
Dir Function
FileAttr Function
FileDateTime Function
FileLen Function
GetAttr Function
Financial
DDB Function
FV Function
IPmt Function
IRR Function
MIRR Function
NPer Function
NPV Function
Pmt Function
PPmt Function
PV Function
Rate Function
SLN Function
SYD Function
Inspection
Environ Function
GetAllSettings Function
GetSetting Function
IsArray Function
IsDate Function
IsEmpty Function
IsError Function
IsMissing Function
IsNull Function
IsNumeric Function
IsObject Function
TypeName Function
VarType Function
Math
Abs Function
Atn Function
Cos Function
Exp Function
Int, Fix Functions
Log Function
Rnd Function
Round Function
Sgn Function
Sin Function
Sqr Function
Tan Function
Messages
Miscellaneous
CallByName Function
IMEStatus Function
MacID Function
MacScript Function
QBColor Function
RGB Function
Spc Function
Tab Function
Program Flow
Choose Function
DoEvents Function
IIf Function
Switch Function
SQL Aggregate
Avg Function
Count Function
First, Last Functions
Min, Max Functions
StDev, StDevP Functions
Sum Function
Var, VarP Functions
Text
Format Function
InStr Function
InStrRev Function
LCase Function
Left Function
Len Function
LTrim, RTrim, and Trim Functions
Mid Function
Replace Function
Right Function
Space Function
StrComp Function
StrConv Function
String Function
StrReverse Function
UCase Function
Coming across your webpage has been one of my highlights this January. This is what quality content looks like. The style, language and delivery meets every ECFMG CERTIFICATION REQUIREMENTS
ReplyDeleteI gotta make sure to bookmark this link and check out more of your content. Not everyday you learn HOW TO BECOME ECFMG CERTIFIED , so this was very timely. Keep up the good work dear.