T Ter May 5, 2009 #1 Ranking issue. I need the ranking to state the following: # of # Is there a way to do this?
D Duane Hookom May 5, 2009 #2 In the Northwind, you can create this with the Employees table with SQL like: SELECT (Select Count(*) FROM Employees e1 where e1.EmployeeID <=Employees.EmployeeID) & " OF " & (SELECT COUNT(*) FROM Employees) AS Rank, Employees.* FROM Employees;
In the Northwind, you can create this with the Employees table with SQL like: SELECT (Select Count(*) FROM Employees e1 where e1.EmployeeID <=Employees.EmployeeID) & " OF " & (SELECT COUNT(*) FROM Employees) AS Rank, Employees.* FROM Employees;
