R robin123 Registered User. Local time Today, 04:09 Joined Nov 14, 2006 Messages 20 Nov 22, 2006 #1 I would like to create a seperate field for each record in my query which would number the results of the query in ascending order, say from 1 to 100. Is it possible to do this in a query?
I would like to create a seperate field for each record in my query which would number the results of the query in ascending order, say from 1 to 100. Is it possible to do this in a query?
neileg AWF VIP Local time Today, 04:09 Joined Dec 4, 2002 Messages 5,970 Nov 22, 2006 #2 Do a search. Been done before. In essence, it's possible. Very easy to do in a report, mind you, which supports a running sum function.
Do a search. Been done before. In essence, it's possible. Very easy to do in a report, mind you, which supports a running sum function.
