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"))