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

  • Thread starter Thread starter jdriv
  • Start date Start date
J

jdriv

Can I create a field displaying part of another field using a character (-)
to stop the output.
 
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.
 
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)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access How to check that the value of a field in a new record is not present in 2 fields of the table? 0
Create a web site link from a part link and a data field in access 2003 1
Access Field won't show as currency in the form, shows just a number (but works fine in the query) 1
Extracting part of a field 2
Change the color of each capital letter in a rich text memo field. 0
Calculated Field Issue 9
Create a table based on another table. 3
Make Searches Match Any Part of Field 2

Back
Top