[2005] SQL ROWNUMBER and DISTINCT

[Simply Me]

Hi! I am creating a report using report viewer. I can already display the desired report except that I would like to add numbering beside my records.
Example:
1. Doe John M. Male
2. Tuesday Mark Male
1. Park Mark Female
2. Stew Lindsey Female

I saw this code

SELECT ROW_NUMBER() OVER (PARTITION BY Gender ORDER BY Age) AS [Partition by Gender], 
       FirstName, 
       Age,
       Gender 
  FROM Person

I have this code in my app

SELECT DISTINCT (IDNo), LastName, FirstName, MiddleName, Gender FROM table1

I tried to combine it like this

SELECT ROW_NUMBER() OVER (PARTITION BY Gender ORDER BY LastName) AS ROWID,DISTINCT (IDNo), LastName, FirstName, MiddleName, Gender FROM table1

but it's not working.