Parsing in a query

[deb]

I am using Access97.


The field in the query looks like...

John|A|Doe|30Mar2003|G1

I need to break this down into seperate fields...

Name Date Dept
John A Doe 30Mar2003 G1

What is the best way to parse this type of data?

Thanks in advance

 

[Corticus]

Ah, and she was in 97.

So all that code was of some use, that's good!

Thanks for the extra info, that's good to know,
Corticus

 

[deb]

Thank you,


I'll try this.