Ranks and ties

Hello, I have a table that contains info on big companies and the number of employees at each. Like this: Table Companies -------------------------------- CoName CoCity CoEmployees I run a query that outputs the data by CoEmployees descending, so that the largest companies are listed first. The output is a simple HTML table. Now I want to add a column to the output that shows the RANK of each company and I have two questions: 1. How, exactly, do I do that? I'm unsure of the best/fastest method. 2. How do I deal with companies that have the same number of employees? I would like them to share the rank. Thanks in advance for hints/suggestions. --- mtonelli@bway.net phone 718 728 7567 * fax 718 728 4420