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