Selecting Text Within a Field to Display

[robk5787]

It seems that this would be easy, and it may be, but I cannot seem to find a way to only display certain text within a field. I have 5 fields that I am querying for and opening a report to display the results. I want to only show certain text out of one field due to all the garbage data within that field. Any help would greatly appreciated. Thanks everyone!

 

[Mile-O]

Some functions for you to look up:

• Left()
• Right()
• Mid()
• InStr()