How to do an order counter id

[ecabanas]

Hi guys

I have a table with the CUSTACCOUNT, SALESID and CREATEDDATETIME. In the master table obviously I have several CUTACCOUNT and SALESID, but I would like to "numerate" the orders, in order to know Frequency, etc etc. as in the following table

Many many thanks

Eduard

CUSTACCOUNT	SALESID	CREATEDDATETIME	Order Number
C000002	PV00161412	16/09/2011	1
C000002	PV00161447	19/09/2011	2
C000002	PV00161459	20/09/2011	3
C000002	PV90000115	17/10/2011	4
C000002	PV00162773	28/12/2011	5
C000002	PV90000251	28/12/2011	6
C000002	PV00163615	10/02/2012	7
C000002	PV00167426	02/08/2012	8
C000002	PV00167833	17/08/2012	9
C000002	PV00172148	26/10/2012	10
C000002	PV00175058	12/12/2012	11
C000002	PV00175672	22/12/2012	12
C000002	PV00176305	04/01/2013	13
C000002	PV00177766	25/01/2013	14
C000002	PV00179238	15/02/2013	15
C000002	PV00181063	13/03/2013	16
C000002	PV00182098	01/04/2013	17
C000002	PV00183345	19/04/2013	18
C000002	PV00184958	13/05/2013	19
C000002	PV00186269	30/05/2013	20
C000002	PV00189628	04/07/2013	21
C000002	PV00192653	13/08/2013	22
C000002	PV00195781	16/09/2013	23

[ecabanas]

Hi sunny,

Now The script is working EXCELLENT many many thank's, if you come to Barcelona you'll have a paella ready to eat 😉

[sunny_talwar]

Awesome, now I soon need to plan a trip to Barcelona then