Results 1 to 2 of 2
  1. #1
    4 Star Lounger
    Join Date
    Mar 2005
    Location
    Leicestershire, United Kingdom
    Posts
    506
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Field, only need the first letter (2000)

    Quickie,

    I have a field for first name, but only want to get the first letter so I can use it as an initial in a letter to them, any ideas how to do this in a query?
    Best Regards,

    Luke

  2. #2
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Field, only need the first letter (2000)

    Hi Luke

    In the query place this

    FInit: =left([myField],1)

    where [myField] is the name of the field that contains the first name
    Jerry

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •