Is there a function to create a field from part of another field?

J

jdriv

Can I create a field displaying part of another field using a character (-)
to stop the output.
 
J

John W. Vinson

Can I create a field displaying part of another field using a character (-)
to stop the output.
Click to expand...

"part"? Which part? And what do you mean by "to stop the output"???

Please give an example of the data in the fields (perhaps with fieldnames) and
the desired output.
 
F

fredg

Can I create a field displaying part of another field using a character (-)
to stop the output.
Click to expand...

We cannot see your database nor read your mind.
A brief example saves a lot of guessing.

Something like having "ASD-ZXC" and getting "ASD" and "ZXC"?

=Left([FieldName],InStr([FieldName],"-")-1)
and
=Mid([FieldName],InStr([FieldName],"-")+1)
 
Top