Query to fill in record number based on query results

[sanders720]

I am doing a query on some data. The data has a field called BubbleNum. This field needs to be filled in based on the record number of the query after I do a sort, replacing existing garbled data. In other words, item 1 in the query would be BubbleNum = 1. Item 1456 would be BubbleNum = 1456. The information only needs to be available long enough to perform the query and change the data.

 

[tlbroadbent]

Check thread181-142288 for various methods of creating a row number in a query. Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.