Results 1 to 4 of 4

Thread: Formula Help

  1. #1
    Join Date
    Mar 2004
    Posts
    56

    Unanswered: Formula Help

    This most likly easy but it has me stumpped, still not that great at access here.

    I have a level of commitment field that ranges from 1 to the tens of thousands. Within this one field what I need is a formula that pulls 26 and under as well as 69,000 and under, but skips anything greater then 26 and less than 52. So essetially 1-26 and 53-69,000.

    thank you

  2. #2
    Join Date
    Sep 2004
    Location
    Reston, VA
    Posts
    86
    Use this in the criteria section in a query on that field:

    >=53 Or <=26

  3. #3
    Join Date
    Sep 2004
    Location
    Charlotte, NC
    Posts
    164
    a slight correction on the criteria statement. it should be '<=26 Or (>=53 And <=69000)'.

    TD

  4. #4
    Join Date
    Feb 2004
    Location
    Chicago, IL
    Posts
    1,312
    Another way, which I believe is easier to read is:

    Between 1 and 26 Or Between 53 and 69000

Posting Permissions

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