HELP HOW TO NUMERATE THE QUEY RESULTS?

[[MVP] S.Clark]

Call a function from the query that has a static variable that increments
sequentially.

Something like:

Function NextNum()

static lngVal as long

lngVal = lngVal + 1

Next Num = lngVal

End Function

(I can't remember the syntax for Static off the top of my head, so check the
help file)