Update like this

  • Thread starter Thread starter ooxx
  • Start date Start date
O

ooxx

Hello everybody,

I want the ACESS to do than on me, but how to make it work for me. I'd
like it to update the following data for example : Field1 as text and the
data is 1, 2,3,..,,100 . I 'd like the ACESS to update this data into :
a123, 1,2,3, a456, 4,5,6, a678, 6,7,8 ... ,a979899,97,98,99, a100, 100

Thanks
 
Your example is unclear. Are the records like this --
1
2
3
....
100
and you want it to be like this --
A1
A2
A3
....
A100 ? If that is not what you want then lay out example as I did.
 
Hooley Everybody,

This is not I want. The Data is Field1 as text and the data is as follows:

Field1
1
2
3
..
..
..
100

yes , and I want ACCESS to do than on me into this way.

Field1
A123
1
2
3
A456
4
5
6
..
..
..
A979899
97
98
99
A100
100

Only if in case there is only 100. Hope is this may get.
Thanks,
 
Back
Top