Create Unique Number

[zyus]

I hv the following format of records in my acno field (text field)

ACNO
00104/67/011601/34
00104/67/011257/68
00104/67/014142/62

In a query i want to create a field that will sum all the number as per
example below
NewACNO
00104+67+011601+34 11806
00104+67+011257+68 11496
00104+67+014142+62 14375

I managed to come out with this unfinished statement in query but unable to
complete the rest

NewACNO: Val(Left([acno],5))+

Thanks

 

[Tom Wickerath]

Hi Zyus,

How about this?

NewACNO: Eval(Replace([ACNO],"/","+"))


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
__________________________________________

 

[zyus]

Fantastic....Thanx a lot Tom

Hi Zyus,

How about this?

NewACNO: Eval(Replace([ACNO],"/","+"))


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
__________________________________________

I hv the following format of records in my acno field (text field)

ACNO
00104/67/011601/34
00104/67/011257/68
00104/67/014142/62

In a query i want to create a field that will sum all the number as per
example below
NewACNO
00104+67+011601+34 11806
00104+67+011257+68 11496
00104+67+014142+62 14375

I managed to come out with this unfinished statement in query but unable to
complete the rest

NewACNO: Val(Left([acno],5))+

Thanks