but the problem is: i want to co 1

[virginie]

but the problem is:

i want to combinate year+index as 4 digits

and when i do it i lost the the 4 digits:
ydate = DatePart("yyyy", date)

orderfullID = ydate & "-" & id_order


-----> 2002-1 and not 2002-0001

how can i do that ?
i tried:
orderfullID = ydatee & "-" & STR(id_order)
but it doesnt accept the STR() function

how can i cast the long integer to string with format "0000"???

 

[KenReay]

Hi

orderfullID = ydate & "-" & Format(id_order,"0000&quot


Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[virginie]

thanks!

you got a star!!