Hi Everyone,

Can someone help me please,
I am trying to assign a visit number according to the date for each visitor based on their unique number.

Visitor_ID....Visit_Date
1................July 1/2013
1................July 3/2013
1................Aug 2/2013
2................july 10/2013
2................July 15/2013

I would like to add a column to assign a visit number:

Visitor_ID....Visit_Date...........Visit_number
1................July 1/2013.........1
1................July 3/2013.........2
1................Aug 2/2013.........3
2................july 10/2013........1
2................July 15/2013........2

I really appreciate your help,

Thanks,
Amanco