Public Function SequenceLong( _ ByVal vAnything As Variant _ ) As Long
SequenceLong("Alpha") = 1 SequenceLong("Bravo") = 2 SequenceLong("Charlie") = 3See also:
SequenceLongBE Function (In file ESTINAC2.TXT, et. al.) NowUnique Function RandomLongArg FunctionvAnything: The value of one or more columns within the Access Query. For each unique value of the expression passed via vAnything, Microsoft Access will call this function once to get a sequence number. If one or more Query rows have the same value for vAnything, Microsoft Access will use the previous result that was calculated by calling the function with the same argument. (There is no way to tell Microsoft Access that a function is "volatile" and to cause it to evaluate the function once for each row within the Query.)
Copyright 1996-1999 Entisoft
Entisoft Tools is a trademark of Entisoft.