Split field value into two

[Poppy]

Dear Sirs/Madams

Is it possible to split the data in a field into two using a query?

AccountNo
58850119
45457489
58883939
86584747

TO THIS

PubAccountNo             PrivAccountNo
5885                      0119
4545                      7489
5888                      3939
8658                      4747

I appreciate all your help

Kind Regards

 

[ColinEssex]

Look up the LEFT() and RIGHT() functions in Access help.

Left([YourField],4)

etc

Col

 

[Poppy]

Thanx

Kind Regards