G Guest Apr 9, 2006 #1 How to set up a function in access that will display three possible outcomes in a query.
F fredg Apr 9, 2006 #2 How to set up a function in access that will display three possible outcomes in a query. Click to expand... ColumnName:IIf([Question] = "Specific","Answer is probably easy",IIf([Question]<>"Specific","Answer is of no value","Try again"))
How to set up a function in access that will display three possible outcomes in a query. Click to expand... ColumnName:IIf([Question] = "Specific","Answer is probably easy",IIf([Question]<>"Specific","Answer is of no value","Try again"))
D Duane Hookom Apr 9, 2006 #3 Is there an example of what you have and what you want? Your question is way too vague.
J John Vinson Apr 10, 2006 #4 How to set up a function in access that will display three possible outcomes in a query. Click to expand... ColumnName:IIf([Question] = "Specific","Answer is probably easy",IIf([Question]<>"Specific","Answer is of no value","Try again")) Click to expand... <doubletake> <applause> Yep. Answers the question as asked AND prompts the questioner to clarify, all in one go. John W. Vinson[MVP]
How to set up a function in access that will display three possible outcomes in a query. Click to expand... ColumnName:IIf([Question] = "Specific","Answer is probably easy",IIf([Question]<>"Specific","Answer is of no value","Try again")) Click to expand... <doubletake> <applause> Yep. Answers the question as asked AND prompts the questioner to clarify, all in one go. John W. Vinson[MVP]
