display part of a field

  • Thread starter Thread starter alecgreen
  • Start date Start date
A

alecgreen

Hi

I have a text field within my query that I want to display part of:
for example "microsoft" and I just want to display "micro"

Many Thanks

Alec
 
alecgreen said:
I have a text field within my query that I want to display part of:
for example "microsoft" and I just want to display "micro"
Click to expand...

Use:
- Left() if you want the left-most characters;
- Mid() if you want characters from the middle;
- Right() if you want the right-most characters.

You may also need to use:
- Len() to calculate how long it is;
- Instr() to locate where one string is found in another.

If you are trying to parse particular words from the string, this may help:
http://allenbrowne.com/func-10.html
For example, after copying the function into your database, you would type
this expression into the Field row in query design to parse the last word
from a field named F1:
ParseWord([F1], -1)
 
Back
Top