Results 1 to 2 of 2
  1. #1
    tkelley1620 is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Oct 2012
    Posts
    1

    Somewhat new to access.

    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 query [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 offiers that only have 50% but without using the cryteria field.
    Can someone help?
    Not exactly sure how to do this and am a bit stuck thank you


    tom

  2. #2
    orange's Avatar
    orange is offline Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,849
    You should review this to help with database design.
    http://forums.aspfree.com/attachment...2&d=1201055452

    Also,if you use a naming convention that does not allow embedded spaces in field or object names, you will save yourself from a lot of grief and syntax errors.

    Name is a reserved word in Access. Here is a link with a number of reserved words.
    http://allenbrowne.com/AppIssueBadWord.html

    The real key to successful database is table design. Before getting too involved with Queries, make sure your table(s)
    is Normalized.

    Good luck with your project.

Please reply to this thread with any new information or opinions.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums