Number Duplicates with a Calculated Field in Query

[ShocWave]

I'm trying to make a calculated field in query that will number duplicates, not count them.

For example, I have a table with the following:

Joe
Joe
Joe
Mary
Mary
Henry
Dave
Dave
Dave
Dave

I want the query to display:

Joe #1
Joe #2
Joe #3
Mary #1
Mary #2
Henry #1
Dave #1
Dave #2
Dave #3
Dave #4

Any ideas? I'm faily new to to Access and I've been trying to get that to work for awhile now.

[June7]

Check out the links in this thread https://www.accessforums.net/queries...-id-18836.html