Domain functions
Access refers to domain functions what in other environments is called aggregate functions.
dCount | |
dMin, dMax | |
dSum | |
dAvg | |
dFirst, dLast | |
dLookup | Returns the value the expression where criteria matches. If criteria matches multiple rows, the function returns the evaluated expression from a non-deterministic row. |
dStDev, dStDevP | Estimate standard deviation across a population sample (dStDev) or a population (StDevP). |
dVar, dVarP | Estimate variance across a population sample (dVar) or a population (dVarP). |
Parameters
All domain functions accept three parameters of which the last one is optional:
dFunc( expr , domain [, criteria ])
domain is the table or query (view) where dFunc(expression) is applied.
criteria corresponds to the where clause.
Example
The following example roughly corresponds to select lastName from users_v where user_id = 7128:
debug.Print(dLookup("lastName", "users_v", "user_id = 7128"))