Results 1 to 2 of 2
  1. #1
    mkallover is offline Novice
    Windows XP Access 2007
    Join Date
    Sep 2010
    Posts
    25

    Return records where ID contains leading letters


    How can I run a query that will return only those records where the ID field contains two leading letters?

    Some of the IDs are 100% numeric but some of them are formatted like XX12314. I only want to return those where the two leading characters are any letter.

    Is ISNUMERIC the best solution here or is there a better way to do it?

  2. #2
    hertfordkc is offline 18 year novice
    Windows XP Access 2007
    Join Date
    Mar 2011
    Posts
    481

    Brute force way:

    add two calculated fields which contain the first and second character. In the criteria, specify that both are in a character set or not numeric.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Function to return a set of records?
    By vicrauch in forum Access
    Replies: 2
    Last Post: 07-12-2011, 08:27 AM
  2. Access not return the records
    By ashutoshNetsity in forum Access
    Replies: 1
    Last Post: 05-09-2010, 04:27 AM
  3. Return all records from Query
    By ysrini in forum Queries
    Replies: 1
    Last Post: 01-15-2010, 09:52 PM
  4. Month to return in Capital Letters
    By Alex Motilal in forum Queries
    Replies: 3
    Last Post: 01-09-2010, 05:19 AM
  5. Replies: 9
    Last Post: 07-16-2009, 09:13 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums