Hi, Need to split field into many fields in a single column
Example
VERSION MS ACCESS 2002 SP3
TABLENAME ALLTOGETHER
ID MILTIGROUP
30499 99474223@$99474223@$ABD4723@$
35185 99465313@$3465135@$
30433 99464286@$4246.86@$742.4686@$99464286@$99464286E@$
RESULT REQUIRED
TABLENAME SEPERATED
ID MULTIGROUPSPLIT
304999 99474223
304999 99474223
304999 ABD4723
35185 99465313
35185 3465135
30433 99464286
30433 4246.86
30433 742.4686
30433 99464286
30433 99464286E
Very basic knowledge in VB so kindly explain function plus calling from a query.