Greater or Less Than Statements

Discussion in 'Microsoft Access Getting Started' started by Dave B, Feb 18, 2004.

  1. Dave B

    Dave B Guest

    Hi,

    I am currently trying to create a query that allows me to add 40 if the
    amount is over 900.

    I can get it to display the amount by adding >900 but i cant figure out how
    to add the 40 onto the result.

    Any help would be greatly appreciated, as i have spent ages messing about
    it.


    Thanks in advance,

    Dave
     
    Dave B, Feb 18, 2004
    #1
    1. Advertisements

  2. Dave B

    Guest Guest

    Try using an UpdateQuery (but make sure to back up your table/db first, just in case).

    Criteria: >900
    UpdateTo: [FieldName] + 40


    ----- Dave B wrote: -----

    Hi,

    I am currently trying to create a query that allows me to add 40 if the
    amount is over 900.

    I can get it to display the amount by adding >900 but i cant figure out how
    to add the 40 onto the result.

    Any help would be greatly appreciated, as i have spent ages messing about
    it.


    Thanks in advance,

    Dave
     
    Guest, Feb 18, 2004
    #2
    1. Advertisements

  3. In your query (design view) add a new column calcamt: IIF([amount]>900,
    [amount]+40, [amount])



    "Dave B" <> wrote in message
    news:5ZJYb.4151$...
    > Hi,
    >
    > I am currently trying to create a query that allows me to add 40 if the
    > amount is over 900.
    >
    > I can get it to display the amount by adding >900 but i cant figure out

    how
    > to add the 40 onto the result.
    >
    > Any help would be greatly appreciated, as i have spent ages messing about
    > it.
    >
    >
    > Thanks in advance,
    >
    > Dave
    >
    >
    >
     
    Eechhutti R.Rajasekaran, Feb 22, 2004
    #3
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Andrew Anderson

    RANDOM AUTONUMBERS greater than zero?

    Andrew Anderson, Dec 24, 2003, in forum: Microsoft Access Getting Started
    Replies:
    2
    Views:
    213
    Guest
    Dec 25, 2003
  2. Bill Malmgren

    Greater than date to multiple criteria

    Bill Malmgren, Sep 9, 2004, in forum: Microsoft Access Getting Started
    Replies:
    1
    Views:
    234
    Van T. Dinh
    Sep 10, 2004
  3. Bill Malmgren

    query date and greater than date

    Bill Malmgren, Feb 5, 2005, in forum: Microsoft Access Getting Started
    Replies:
    1
    Views:
    196
    Ken Snell [MVP]
    Feb 5, 2005
  4. Guest

    greater than & less than sorting

    Guest, Apr 6, 2006, in forum: Microsoft Access Getting Started
    Replies:
    1
    Views:
    164
    Douglas J Steele
    Apr 6, 2006
  5. Guest

    Notation for greater than/less than when entering data?

    Guest, Nov 12, 2006, in forum: Microsoft Access Getting Started
    Replies:
    8
    Views:
    226
    Guest
    Nov 13, 2006
Loading...

Share This Page