Dear Sirs/Madams
Is it possible to split the data in a field into two using a query?
I appreciate all your help
Kind Regards
Is it possible to split the data in a field into two using a query?
Code:
AccountNo
58850119
45457489
58883939
86584747
TO THIS
PubAccountNo PrivAccountNo
5885 0119
4545 7489
5888 3939
8658 4747
I appreciate all your help
Kind Regards