I have a column of dates and 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.

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?

Thank you!
Barbara