Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2010
    Posts
    3

    Unanswered: Question for you...

    I am relatively new to access so please bear with me.
    I have an access database with the following fileds

    Name
    Years_Purchasing
    Most_Recent_Spend
    LY_Spend Months_Since_Last_Purchase
    New_Customer
    Promotion offer:*


    The promotion offer field has the following IFF statement. [CODE]Promortion Offer: IIf([LY Spend]>=1000,0.5,IIf([LY Spend]>=400,0.25,IIf([LY Spend],0.1)))[/CODE


    In the next step I have to display all the offers that only have 50% but without using the cryteria field as in the desing view.

    Can someone help?
    Not exactly sure how to do this and am a bit stuck thank you
    tom

  2. #2
    Join Date
    Mar 2009
    Posts
    5,442
    Provided Answers: 14
    1. Please always specify which Access object you're referring to: Table, Form, Query, etc. An expression such as:
    Code:
    Promortion Offer: IIf([LY Spend]>=1000,0.5,IIf([LY Spend]>=400,0.25,IIf([LY Spend],0.1)))
    more probably comes from a query.

    Also pay attention to the spelling: [Promortion Offer] and try to refrain form using spaces and other non-alphanumeric characters as well as reserved words in the names of your objects. All these can lead to errors that are sometimes hard to detect.


    2. What do you mean with:
    ... but without using the cryteria field as in the desing view.
    And what's wrong with the IIF expression?

    If you need to conditionally select rows from a table, you'll have to use a condition (or criteria) that, in SQL, can be a WHERE clause, an (INNER) JOIN... ON operation or possibly a HAVING clause.

    Please specify the structure of the table on which the query is built (columns name and data type).
    Have a nice day!

Posting Permissions

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