Reference
The following list contains topics that describe common functions used in Access expressions.
ActiveX
- CreateObject function
- GetObject function
Application
- Command function
- Shell function
Arrays
- Array function
- Filter function
- Join function
- LBound function
- Split function
- UBound function
Conversion
- Asc function
- CBool function
- CByte function
- CCur function
- CDate function
- CDbl function
- CDec function
- Chr function
- CInt function
- CLng function
- CSng function
- CStr function
- CVar function
- Day function
- EuroConvert method
- FormatCurrency function
- FormatDateTime function
- FormatNumber function
- FormatPercent function
- GUIDFromString method
- Hex function
- Nz method
- Oct function
- Str function
- StringFromGUID method
- Type Conversion functions
- Val function
Database
- CurrentUser method
- DDEInitiate method
- DDERequest method
- Eval method
- HyperlinkPart method
- 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 method
- DFirst method
- DLast method
- DLookup method
- DMax method
- DMin method
- DStDev method
- DStDevP method
- DSum method
- DVar method
- DVarP method
Error handling
- CVErr function
- Error function
- IsError function
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
- Fix function
- Int function
- Log function
- Rnd function
- Round function
- Sgn function
- Sin function
- Sqr function
- StDev function
- StDevP function
- Tan function
Messages
- InputBox function
- MsgBox function
Miscellaneous
- CallByName function
- IMEStatus 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
- Max function
- Min function
- StDev function
- StDevP function
- Sum function
- Var function
- VarP function
Text
- Format function
- HtmlEncode method
- InStr function
- InStrRev function
- LCase function
- Left function
- Len function
- LTrim function
- Mid function
- PlainText method
- Replace function
- Right function
- RTrim function
- Space function
- StrComp function
- StrConv function
- String function
- StrReverse function
- Trim function
- UCase function
!include[Support and feedback]