Row Numbers / Numbering Rows (Query or Form)

[ajetrumpet]

This example shows you how to number your rows in a query, and thus be able to do the same in a form based on the query. Queries can be numbered using this same technique when combined with other techniques as well. Such as:

*Sorting
*Grouping
*Calling VBA functions within queries
*Concatenations


This is a simple procedure, and the code is basically as follows:

SELECT DCount("[B]YOURFIELD[/B]","[B]YOURTABLE[/B]",
   "[B]YOURFIELD [/B]<=" & [temp]) AS rownumber, 
      [B]YOURFIELD[/B].[B]YOURTABLE [/B]AS temp

NOTICE: Ordering of the field list in the SELECT statement does not matter here.


Any suggestions welcome on the improvement of this. HTH!