Results 1 to 3 of 3
  1. 12-26-2015, 04:07 AM #1
    hatmal
    hatmal is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Feb 2014
    Posts
    13

    Iif between two numbers

    I have two fields



    max limit increase final increase
    75 106 75
    45 26 26
    30 30 30
    i want to get final increase by access query


    iif increase < max get max limit
    iif increase > get increase


    how do it


    many thanks
    Reply With Quote Reply With Quote
  2. 12-26-2015, 04:16 AM #2
    CJ_London
    CJ_London is offline VIP
    Windows 8 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,933
    basic principle would be

    finallimit:iif(increase > maxlimit,maxlimit,increase)
    Reply With Quote Reply With Quote
  3. 12-26-2015, 04:44 AM #3
    hatmal
    hatmal is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Feb 2014
    Posts
    13
    many thanks
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Similar Threads

  1. Counting Frequency of numbers & comparing to frequency of another set of numbers in same row
    By lhilde01 in forum Access
    Replies: 5
    Last Post: 10-29-2014, 12:12 PM
  2. Design Strategy - Using interchange numbers to show prices for primary key numbers
    By krystalr in forum Database Design
    Replies: 8
    Last Post: 03-10-2014, 11:47 AM
  3. same numbers = differnet numbers?
    By mike02 in forum Queries
    Replies: 1
    Last Post: 07-17-2013, 03:40 PM
  4. Ensuring daa import software version numbers as numbers not dates
    By ptworthing in forum Access
    Replies: 1
    Last Post: 11-29-2011, 08:43 AM
  5. numbers
    By Balen in forum Access
    Replies: 1
    Last Post: 08-17-2010, 05:16 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
  •  

Forum Rules

Other Forums: Microsoft Office Forums