Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2004
    Location
    metro Detroit
    Posts
    634

    Unanswered: Compare multiple fields in same record

    It seems like there should be a function for this.....

    I need to compare several numeric fields in a record and determine which has the greatest value. I could use a big ugly iif statement, but I was wondering if there was a function that could do this.

  2. #2
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Nope, no function. There is in Excel, but that's because it is a common requirement in Excel. In SQL it suggests a violation of first normal form so there is rarely need for it.
    Testimonial:
    pootle flump
    ur codings are working excelent.

  3. #3
    Join Date
    Apr 2004
    Location
    metro Detroit
    Posts
    634
    Thanks for the response, Pootle.

Posting Permissions

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