1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Looking for a programming service... will pay $$$.

Discussion in 'General Programming Chat' started by Dynastic, Mar 7, 2011.

  1. Dynastic

    Dynastic Registered Member

    Joined:
    Dec 15, 2009
    Messages:
    86
    Likes Received:
    113
    Location:
    NY
    If you have:

    -Coding knowledge
    -Familiarity with Microsoft Access and building expressions (For now, IIf statements will be sufficient)

    I'm looking to create a Microsoft Access IIf statement generator.

    Let me explain with a nested If statement in Microsoft Access.
    For example, you have a table with students, all sorted by FR, SO, JR, SR.

    You need to replace FR with Freshman, but it has to be through an IIf statement. Therefore, I want a page that says the following....

    [Everything written in the underlined space = What the user inputted in the blank field]

    How many variables? (User selects 4) 4

    If: __Fr____
    Then:_Freshman______

    If __SO___,
    Then:__Sophomore____

    If: __JR_____
    Then:__Junior_______

    If Not: ___Junior_____ , ___Senior______

    [Generate]

    Upon Clicking generate.... this will display at the bottom:

    IIf([Students]![Class]="FR","Freshman",IIf([Students]![Class]="SO","Sophomore",IIf([Students]![Class]="JR","Junior","Senior")))


    If anyone is willing to give me some input, I'd really appreciate it.
    -Joe