Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2002
    Posts
    5

    Unanswered: query that uses 'starts with'??

    Are there any criteria that I can add to my query that will allow me to query and filter a field by using something like, 'field starts with'??

    Any help would be great.

    Thanks in advance,

    Ian


  2. #2
    Join Date
    Aug 2002
    Location
    Charlotte NC
    Posts
    665

    Re: query that uses 'starts with'??

    Originally posted by imcivor
    Are there any criteria that I can add to my query that will allow me to query and filter a field by using something like, 'field starts with'??

    Any help would be great.

    Thanks in advance,

    Ian

    the function u want is mid ie

    in the criteria row put

    mid(columnname,1,1) = "M"

    look up mid in the access help for more detail on its useage
    Regards Jim

Posting Permissions

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