extacting first name from a field

have a field that has first name and first initial. I want to only extract
the first name in a query.

So if I have John R. I only want to extract John. In a Query I wrote
this syntax: =left([FirstName], Find(" ",[FirstName]))

But the Find doesn't seems to exist in Access (it does in Excel). I also
tried this with substituting Find with Match.. no luck there either.
How would I do this?

Thanks
.

Relevant Pages

  • Re: Weight returning unexpected results
    ... John, thanks for your reply. ... although now I just ran the same query and I'm getting the results I ... I'll see if I can find anything in the BOL, ... Prev by Date: ...
    (microsoft.public.sqlserver.fulltext)
  • performance question/multiple keys
    ... The table I'm using has full-text columns and also a date column thats ... If I do a query on a date range and the full-text column does SQL ... John ... Prev by Date: ...
    (microsoft.public.sqlserver.fulltext)
  • Extracting certain information from a column
    ... I'm trying to extract certain information from a column and I can't seem to ... Sometimes the letter changes to ZO, ... The Query will look like, ... Prev by Date: ...
    (microsoft.public.access.queries)
  • Using AND and OR together in sql
    ... I've tried to make a search an AND OR query ... record with name of John or Paul of age 32 and simply name of John or Paul. ... Prev by Date: ...
    (microsoft.public.vb.general.discussion)
  • return a specific part of a field
    ... I have a field T008 that is data type memo. ... I need to extract just position number 33 of this field and ... How can I do this in a query? ... Prev by Date: ...
    (microsoft.public.access.queries)