An unlinked incrementing counter field in query results?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Counter 1
Access Dcount (multiple criteria) 3
Incrementing a Counter 7
Error Message - Macro to Unlink MS Queries from Workbook 0
Date/Time group by 2 hr increments. 1
Creating an index in a query 8
Unlinked Tables affecting Query? 5
Appending Records Using DMAX 4

Back
Top