The following topics describe common functions used in Access expressions.
Common Access expression functions
- Abs function
- Array function
- Asc function
- Atn function
- Avg function
- CallByName function
- CBool function
- CByte function
- CCur function
- CDate function
- CDbl function
- CDec function
- Choose function
- Chr function
- CInt function
- CLng function
- Command function
- Cos function
- Count function
- CreateObject function
- CSng function
- CStr function
- CurDir function
- CurrentUser method
- CVar function
- CVErr function
- Date function
- DateAdd function
- DateDiff function
- DatePart function
- DateSerial function
- DateValue function
- DAvg function
- Day function
- DCount method
- DDB function
- DDEInitiate method
- DDERequest method
- DFirst method
- Dir function
- DLast method
- DLookup method
- DMax method
- DMin method
- DoEvents function
- DStDev method
- DStDevP method
- DSum method
- DVar method
- DVarP method
- Environ function
- EOF function
- Error function
- EuroConvert method
- Eval method
- Exp function
- FileAttr function
- FileDateTime function
- FileLen function
- Filter function
- Fix function
- Format function
- FormatCurrency function
- FormatDateTime function
- FormatNumber function
- FormatPercent function
- FreeFile function
- FV function
- GetAllSettings function
- GetAttr function
- GetObject function
- GetSetting function
- GUIDFromString method
- Hex function
- Hour function
- HtmlEncode method
- HyperlinkPart method
- IIf function
- IMEStatus function
- Input function
- InputBox function
- InStr function
- InStrRev function
- Int function
- IPmt function
- IRR function
- IsArray function
- IsDate function
- IsEmpty function
- IsError function
- IsMissing function
- IsNull function
- IsNumeric function
- IsObject function
- Join function
- LBound function
- LCase function
- Left function
- Len function
- Loc function
- LOF function
- Log function
- LTrim function
- Max function
- Mid function
- Min function
- Minute function
- MIRR function
- Month function
- MonthName function
- MsgBox function
- Now function
- NPer function
- NPV function
- Nz method
- Oct function
- Partition function
- PlainText method
- Pmt function
- PPmt function
- PV function
- QBColor function
- Rate function
- Replace function
- RGB function
- Right function
- Rnd function
- Round function
- RTrim function
- Second function
- Seek function
- Sgn function
- Shell function
- Sin function
- SLN function
- Space function
- Spc function
- Split function
- Sqr function
- StDev function
- StDevP function
- Str function
- StrComp function
- StrConv function
- String function
- StringFromGUID method
- StrReverse function
- Sum function
- Switch function
- SYD function
- Tab function
- Tan function
- Time function
- Timer function
- TimeSerial function
- TimeValue function
- Trim function
- TypeName function
- UBound function
- UCase function
- Val function
- Var, VarP functions
- VarType function
- Weekday function
- WeekdayName function
- Year function
!include[Support and feedback]