I have a column of dates then I have a column called Date Sequence number.
I want the sequence number to start at 1 and increase by one on each row
until the Date changes, then I want the date sequence number to start over at
one and Keep increasing by one until the date changes again. The date will
always be the same on each row until then next day.
For example.

Date Date Seq Nbr
08/16/09 1
08/16/09 2
08/16/09 3
08/17/09 1
08/17/09 2
08/17/09 3
08/17/09 4
08/17/09 5
08/18/09 1
08/18/09 2
08/19/09 1
08/19/09 2
08/19/09 3
08/19/09 4

I will enter the Date filed on each row but I want the Date Seq Nbr to
automatically fill and increase without having to type it in.
Can this be done? If so how?