Results 1 to 2 of 2

Thread: len() (2003)

  1. #1
    2 Star Lounger
    Join Date
    Jan 2004
    Posts
    196
    Thanks
    1
    Thanked 0 Times in 0 Posts

    len() (2003)

    I am making a query to use in a combo box. The query has one field, Equip, and has Total: Group by. This is a list of all my equipment, owned and rented. I need to pull out the owned equipment, which has this format: 10-011. I tried to use the following in the criteria: Len(Equip)>"6", b/c all the rented equipment is entered as a description (rent water wagon) or date (10-10-30), the first 10 is this type of equip, the next two are the date. This did not work, it did not pull the ones with descriptions.

    Is there a better way to do this???


    thanks,
    jackal

  2. #2
    2 Star Lounger
    Join Date
    Jan 2004
    Posts
    196
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: len() (2003)

    this appears to work:

    Not like "##-###"


    thanks,
    jackal

Posting Permissions

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