Left(str,???), words not character

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Can anyone help me to solve this problem in report?

e.g. Table = Fruit
Banana 18kg
Pineapple 5kg
Papaya 6kg

If i use ==> Left([fruit],1)
Result B
P
P
But actually i want
Banana
Pineapple
Papaya

In short, i want the left word.

Any Ideas ?

Thanks from
kennykee
 
Can anyone help me to solve this problem in report?
e.g. Table = Fruit
Banana 18kg
Pineapple 5kg
Papaya 6kg

If i use ==> Left([fruit],1)
Result B
P
P
But actually i want
Banana
Pineapple
Papaya

In short, i want the left word.
Click to expand...

Left([fruit], Instr([[fruit] & " ", " ") - 1)

Tom Lake
 
Thanks Tom
That Really Works

But you overtype one more brackett ...........[[fruit]...........

Thanks anywhere, your help is really appreciated

Thank You
 
Back
Top