I have a table that contains a person's ID and an address field. There may be multiple addresses per person. What I would like to do is have a table or query that will return a Row Number for each respective address...should look something like this...
ID Address Count Address
1 1 111 Main Street
1 2 P.O. Box 111
2 1 999 Market Street
ID Address Count Address
1 1 111 Main Street
1 2 P.O. Box 111
2 1 999 Market Street