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
-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