Help

[Ter]

Ranking issue. I need the ranking to state the following:

# of #

Is there a way to do this?

 

[Duane Hookom]

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;