String Functions:
| ||||
Asc | InstrRev | Mid | Str | |
Chr | LCase | Replace | StrConv | |
Concat with & | Left | Right | Trim | |
Format (with Strings) | Len | RTrim | UCase | |
Instr | LTrim | Space |
Advanced Functions:
| ||||
Case | First | IsDate | Last | |
Choose | iif | IsNull | Nz | |
CurrentUser | IF-THEN-ELSE | IsNumeric | Switch |
Domain Aggregate Functions:
| ||||
DAvg | DFirst | DLookup | DMin | |
DCount | DLast | DMax | DSum |
Numeric/Mathematical Functions:
| ||||
Abs | Count | Int | Round | |
Atn | Exp | Max | Sgn | |
Avg | Format (with Numbers) | Min | Sum | |
Cos | Fix | Rnd (random number) | Val |
Date Functions:
| ||||
Date | DateValue | Month | TimeSerial | |
DateAdd | Day | MonthName | TimeValue | |
DateDiff | Format (with Dates) | Now | Weekday | |
DatePart | Hour | Second | WeekdayName | |
DateSerial | Minute | Time | Year |
Data Type Conversion Functions:
| ||||
CBool | CDate | CInt | CStr | |
CByte | CDbl | CLng | CVar | |
CCur | CDec | CSng |
Functions used by Group By Feature in queries:
| ||||
Avg | Max | Sum | ||
Count | Min |
File/Directory Functions:
| ||||
ChDir | Dir | GetAttr | ||
ChDrive | FileDateTime | MkDir | ||
CurDir | FileLen | SetAttr |
No comments:
Post a Comment