Results 1 to 5 of 5
  1. #1
    weric77
    Guest

    Query Question (97)

    I would like to create a query to retrieve a specfic value in the 13 th position of an 18 charater text field.

    I have used the like command with *, however it gives me more records then I need. Any help would be appreciated

  2. #2
    Star Lounger
    Join Date
    Sep 2001
    Location
    SC, USA
    Posts
    60
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Query Question (97)

    MID([FieldName],start_num,num_chars). For your query use: Mid([YourFieldName],13,1) <img src=/S/chatter.gif border=0 alt=chatter width=38 height=16>

  3. #3
    Star Lounger
    Join Date
    Sep 2001
    Location
    SC, USA
    Posts
    60
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Query Question (97)

    I replied too quickly. You want to use this on the criteria line of your query, for the text field you mentioned: Mid([YourFieldName],13,1) ="value". Replace "value" with the value you're looking for.

  4. #4
    Star Lounger
    Join Date
    Sep 2001
    Location
    SC, USA
    Posts
    60
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Query Question (97)

    If you want a parameter query, then instead of my previous reply, create a new column in your query with the field name as an expression: Mid([YourTextFieldName],13,1). Then in the criteria of this new column put this: [Enter Value].

  5. #5
    weric77
    Guest

    Re: Query Question (97)

    Thank you ever so much this was exactly what I needed!

    Thanks, again

Posting Permissions

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