Numbering Records with sort

[Keith S]

Bumping this up to the top for one last question.

One last question about this, in my table it is sorted by Facility and Cycle
Time. I want it to number how it is sorted in the table. Is there syntax to
have it sort that way? I have tried moving the fields around in the select
statement and in the Group By.

Thanks again.

 

[Marshall Barton]

One last question about this, in my table it is sorted by Facility and Cycle
Time. I want it to number how it is sorted in the table. Is there syntax to
have it sort that way? I have tried moving the fields around in the select
statement and in the Group By.

Take a look at http://allenbrowne.com/subquery-01.html