Math/Logic Functions
Abs - returns the absolute value;
Cos - returns the value specifying the cosine of an angle;
Exp - returns e (exponent) raised to the power of a value;
If - returns 1 if expression is true, otherwise 0 is returned;
Int - returns the integer portion of a number;
Log - returns the value specifying the natural logarithm of a value;
Pow - returns base raised to the power of exp.;
Round - returns the rounded value to specified precision;
Sgn - returns the number indicating the sign of a value;
Sin - returns the value specifying the sine of an angle;
Sqr - returns the square root of a number;
V - returns the value of a variable.
Learn more...
Date Functions
dateSerial - returns the date for the specified year,
month and day;
datePart - returns the specified part of the
date;
dateCurrent - returns the current system date;
dateDiff - returns the interval between two dates;
dateAdd - returns the date shifted from date to a specified interval;
Learn more...
Data Functions
F - returns the value of a field of the current record;
RF - returns the value of a field of the specified record;
FLen - returns the length of a field of the current record;
User - returns user input.
Learn more...
Functions for Recordset
Return results of operations (sum, avrage, etc) for records from:
folMathOp - specified folder;
mmrMathOp - many-to-many field
;
setMathOp - recordset stored in a variable;
queMathOp - query results;
repMathOp - report;
subMathOp - grouped records in a report;
cexMathOp - custom export;
Return numbers of records in:
folRecN - specified folder;
mmrRecN - many-to-many field;
setRecN - recordset stored in a variable;
queRecN - query results;
repRecN - report;
subRecN - grouped records in a report;
cexRecN - custom export.
Learn more...
| |
|
|
All topics in the "Functions Description" section:
|
|