Functions available in PivotTable or PivotChart view of a form
Microsoft Office Access 2003
| ABS |
ARRAY |
| ASC |
ASCB |
| ASCW |
ATN |
| CBOOL |
CBYTE |
| CCUR |
CDATE |
| CDBL |
CHOOSE |
| CHR |
CHR$ |
| CHRB |
CHRB$ |
| CHRW |
CHRW$ |
| CINT |
CLNG |
| COS |
CSNG |
| CSTR |
CVAR |
| CVDATE |
CVERR |
D - H
| DATE |
DATE$ |
| DATEADD |
DATEDIFF |
| DATEPART |
DATESERIAL |
| DATEVALUE |
DAY |
| DDDB |
ERROR |
| ERROR$ |
EXP |
| FIX |
FORMAT |
| FORMAT$ |
FV |
| HEX |
HEX$ |
| HOUR |
|
I - L
| IIF |
IMESTATUS |
| INSTR |
INT |
| IPMT |
IRR |
| ISDATE |
ISEMPTY |
| ISERROR |
ISNULL |
| ISNUMERIC |
ISOBJECT |
| ICASE |
ICASE$ |
| LEFT |
LEFT$ |
| LEFTB |
LEFTB$ |
| LEN |
LENB |
| LOG |
LTRIM |
| LTRIM$ |
|
M - Q
| MID |
MID$ |
| MIDB |
MIDB$ |
| MINUTE |
MIRR |
| MONTH |
NOW |
| NPER |
NPV |
| OCT |
OCT$ |
| PARTITION |
PMT |
| PPMT |
PV |
| QBCOLOR |
|
R- S
| RATE |
RGB |
| RIGHT |
RIGHT$ |
| RIGHTB |
RIGHTB$ |
| RND |
ROUND |
| RTRIM |
RTRIM$ |
| SECOND |
SGN |
| SIN |
SLN |
| SPACE |
SPACE$ |
| SQR |
STR |
| STR$ |
STRCOMP |
| STRCONV |
STRING |
| STRING$ |
SWITCH |
| SYD |
|
T - Z
| TAN |
TIME |
| TIME$ |
TIMER |
| TIMESERIAL |
TIMEVALUE |
| TRIM |
TRIM$ |
| TYPENAME |
UCASE |
| UCASE$ |
VAL |
| VARTYPE |
WEEKDAY |
| YEAR |
|