Please, don't send me a copy of each and every message. I will decide for myself which threads I consider insteresting.
You can send me a copy now and then, when it is especially relevant.
>hi,
>
>ok, i try with this code under ,it works.
>
>
>SELECT MAX(billno) from billinfo INTO ARRAY laAarray
>thisform.text1.value=(RIGHT(STR(YEAR(billinfo.billdate),4),2) + '_'+RIGHT(STR(10000+billinfo.billno+1,5),4))
>
>
>
>thanks
>m.qasem
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
