First, Happy Friday.

I'm trying to add a row count to set of records that have the same leading static client identifier. I'm struggling with the syntax. I want to order these records in numeric fashion, and then restart the numeric count when the client identifier changes....

Basically, take my household identifier and then use it to numerically number all the clients in that household. The count starts over with a new household identifier

So (for instance)

Identifier Name Acct Number
80532 John Smith 1234 1
80532 Henry Smith 1243 2
80532 Martha Smith 1234 3
80623 Bill Johnson 5263 1
80623 Nancy Johnson 5263 2

Any thoughts?