An unlinked incrementing counter field in query results?

B

Bart

I need a field in a query that increments it's count with each record found.
Anyone know how to do that? I appreciate it.
 
M

[MVP] S.Clark

This was just a Tip in the back of Access Advisor magazine(Nov 2005)
http://www.Advisor.com

Select ID, Student, num, Count(Unique_Num) as Rank
From Table1, (Select Distinct Num as Unique_Num from Table1) as VTable
where unique_num>=num
group by id, student, num
order by count(unique_num)
 
Top