Create Unique Number

Z

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
 
Z

zyus

Fantastic....Thanx a lot Tom

Tom Wickerath said:
Hi Zyus,

How about this?

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


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

zyus said:
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
Click to expand...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copying records that contain nulls 2
Finding a number in a table? 10
Selecting Columns conditionally? 3
Create new unique invoice number 3
Access 2000: How do I use data to create field names? 3
Need to create an incremental sequence number 3
I need a unique number to be created per worksheet 2
Convert T/F to Number value & Sum multiple fields for further calc 3

Top