| title | Visual Basic for Applications functions | Microsoft Docs | ||
|---|---|---|---|
| ms.prod | sql | ||
| ms.prod_service | connectivity | ||
| ms.technology | connectivity | ||
| ms.custom | |||
| ms.date | 01/19/2017 | ||
| ms.reviewer | |||
| ms.topic | conceptual | ||
| dev_langs |
|
||
| helpviewer_keywords |
|
||
| ms.assetid | ccbdea9d-f9cf-4b0c-ade2-2d65311e12dc | ||
| author | MightyPen | ||
| ms.author | genemi |
The following Visual Basic for Applications functions can be used in data shaping CALC expressions:
| Abs | Asc | Atn | CBool | CByte | CCur |
| CDate | CDbl | Chr | ChrB | ChrW | Chr$ |
| ChrB$ | CInt | CLng | Cos | CSng | CStr |
| Cvar | CVDate | CVErr | Date | Date$ | DateAdd |
| DateDiff | DatePart | DateSerial | DateValue | Day | DDB |
| Error | Error$ | Exp | Fix | Format | Format$ |
| FV | Hex | Hex$ | Hour | IIF | InStr |
| Int | IPmt | IRR | IsDate | IsEmpty | IsError |
| IsNull | IsNumeric | IsObject | LCase | LCase$ | Left |
| LeftB | Left$ | LeftB$ | Len | Log | LTrim |
| LTrim$ | Mid | Mid$ | Minute | MIRR | Month |
| Now | NPer | NPV | Oct | Oct$ | Pmt |
| PPmt | PV | QBColor | Rate | RGB | Right |
| RightB | Right$ | RightB$ | Rnd | RTrim | RTrim$ |
| Second | Sgn | Sin | SLN | Space | Space$ |
| Sqr | Str | Str$ | StrComp | StrConv | String |
| String$ | SYD | Tan | Time | Time$ | Timer |
| TimeSerial | TimeValue | Trim | Trim$ | TypeName | UCase |
| UCase$ | Val | VarType | Weekday | Year |
Accessing Rows in a Hierarchical Recordset
Data Shaping Overview
Formal Shape Grammar
Required Providers for Data Shaping
Shape APPEND Clause
Shape Commands in General
Shape COMPUTE Clause