Query Help!!!

marvin67

Registered User.
Local time
Tomorrow, 07:22
Joined
Apr 8, 2004
Messages
11
How can i break a text field that contains a name where each character in the name is will be on another field.

eg: Firstname
Marvin
will become

F1 | F2 | F3 | F4 | F5 | F6 | F7
M | a | r | v | i | n |

Thanks
 
Marvin,

Expr1: Mid([SomeField], 1, 1)
Expr2: Mid([SomeField], 2, 1)
Expr3: Mid([SomeField], 3, 1) ...

But, Why?

Wayne
 

Users who are viewing this thread

Back
Top Bottom