aziz rasul
Active member
- Local time
- Today, 17:15
- Joined
- Jun 26, 2000
- Messages
- 1,935
First of all I'm NOT a VBA person. Hence the difficulty that I'm currently facing.
The problem is this.
I have 2 tables (tblSFF - Nynex, tblLO's) that contains data like so:-
[tblSFF - Nynex]![New LO Reference]
62600000000000000000
62600000000000000000
62600000000000000000
62700000000000000000
62700000000000000000
62800000000000000000
62800000000000000000
62800000000000000000
62800000000000000000
62900000000000000000
etc
[tblLO's]![LO ID] [tblLO's]![Number]
626 47624
627 52698
628 56245
629 58612
etc etc
I would like a function that would produce the following, in [tblSFF - Nynex]![New LO Reference] i.e.
[tblSFF - Nynex]![New LO Reference]
62600000000000047624
62600000000000047625
62600000000000047626
62700000000000052698
62700000000000052699
62800000000000056245
62800000000000056246
62800000000000056247
62800000000000056248
62900000000000058612
etc
Any ideas. I can email the portion of the relevant bit of the db, if that helps.
[This message has been edited by aziz rasul (edited 12-13-2000).]
The problem is this.
I have 2 tables (tblSFF - Nynex, tblLO's) that contains data like so:-
[tblSFF - Nynex]![New LO Reference]
62600000000000000000
62600000000000000000
62600000000000000000
62700000000000000000
62700000000000000000
62800000000000000000
62800000000000000000
62800000000000000000
62800000000000000000
62900000000000000000
etc
[tblLO's]![LO ID] [tblLO's]![Number]
626 47624
627 52698
628 56245
629 58612
etc etc
I would like a function that would produce the following, in [tblSFF - Nynex]![New LO Reference] i.e.
[tblSFF - Nynex]![New LO Reference]
62600000000000047624
62600000000000047625
62600000000000047626
62700000000000052698
62700000000000052699
62800000000000056245
62800000000000056246
62800000000000056247
62800000000000056248
62900000000000058612
etc
Any ideas. I can email the portion of the relevant bit of the db, if that helps.
[This message has been edited by aziz rasul (edited 12-13-2000).]