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

[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.

Any Ideas ?

Thanks from
kennykee

 

[Tom Lake]

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.

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

Tom Lake

 

[kennykee]

Thanks Tom
That Really Works

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

Thanks anywhere, your help is really appreciated

Thank You