How to take a substring form a field? 1

[patyavila]

Well, I must say first of all THANX to everyone! I allways receive good tips
Have a field that contains "word1 word2 word3 ...". What I need is to show in a report only the first word. I'm quite new in Access, but experienced in programming and know there may be functions that help: find(), substr(), etc.
Any ideas?
Thank you

 

[scriverb]

Use the Mid$ function:

Mid$([[i]fieldname[/i],1,Instr(1,[[i]fieldname[/i]]," ")-1)

This code selects the characters starting at the left and searches for the first space. All to the left of this space is returned.

Bob Scriver
[blue]Want the best answers? See FAQ181-2886[/blue]