Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2011
    Posts
    3

    Unanswered: Selective query in access filed

    I am new to access 2002, I have a field in a query that contains records types, like "P1", "D1", "S2", "P3" etc and I would like to select only records that start with "P". Anyone can help me out?
    Last edited by cac3000; 01-03-11 at 18:36.

  2. #2
    Join Date
    Feb 2004
    Location
    Chicago, IL
    Posts
    1,312
    In the criteria, for the query, put Like "P*". The Like keyword can be used to match parts of strings. The * can be used for one or many characters after the P. A ? will match only one character after the P.

  3. #3
    Join Date
    Jan 2011
    Posts
    3
    Quote Originally Posted by dckunkle View Post
    in the criteria, for the query, put like "p*". The like keyword can be used to match parts of strings. The * can be used for one or many characters after the p. A ? Will match only one character after the p.
    thank so much

Posting Permissions

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