Results 1 to 3 of 3

Thread: expression help

  1. #1
    Join Date
    Mar 2004
    Posts
    56

    Unanswered: expression help

    I have a field with a numeric value that I need AP to clean up. this field should only be 9 digits long so I need to write an expression to pull all records with entries greater or lesser than 9 digits. this way I can pass the report to AP to correct the incorrect entries.

    thank you for your help

  2. #2
    Join Date
    Oct 2003
    Location
    Roanoke, Va
    Posts
    445

    Smile Re: expression help

    Originally posted by roma92
    I have a field with a numeric value that I need AP to clean up. this field should only be 9 digits long so I need to write an expression to pull all records with entries greater or lesser than 9 digits. this way I can pass the report to AP to correct the incorrect entries.

    thank you for your help
    You can put the Len function in the criterea of a query to get values greater or less than 9.

    Len([FieldName]) > 9 Or Len([FieldName] < 9.
    Gregg


    DAO, ADO, SQL, Automation and anything else I can pick up.

  3. #3
    Join Date
    Mar 2004
    Posts
    56

    Talking Re: expression help

    Originally posted by basicmek
    You can put the Len function in the criterea of a query to get values greater or less than 9.

    Len([FieldName]) > 9 Or Len([FieldName] < 9.
    Worked perfectly! Thank you thank you!

Posting Permissions

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