The correspondence of a pronoun with its antecedent in number (singular, plural), person (first, second, third), and gender (masculine, feminine, neuter).
Basic functions. 1  LBound(Array, Rank) â return the lowest subscript (index range) of the VBA Array within a certain dimension (Rank). 2  UBound(Array, Rank) â return the highest subscript (index range) of the VBA Array within a certain dimension (Rank). 3  ReDim â reallocate storage space for the array (set new array size).
In addition to using Microsoft Access functions, queries also support user defined functions. Functions defined in VBA modules must return an appropriate value and can be used to manipulate each record. You can reference field values by passing the field name in brackets.