IF and mutliple selects

[Guest]

Is there a way to do something like an if else so that I can run one of two
selects based on a form field? Something like

IF form!fiield = true
selct ....
else
select....

 

[kingston via AccessMonster.com]

Use the function IIF() in a calculated field:

CalcField: IIF([Forms]![FormName]![FormControl]=True,"ValueTrue","ValueFalse")


I'm not sure if meant you wanted further choices (i.e. a real Select Case...).
If you do, you can nest IIF() statements to achieve this.

 

[Guest]

IIF will not work in this case. A query in Access will not let you start with
iif for one and two if you try this is will not let you return more than one
row. I need to do a select if the value is true that will return multiple
rows.

Use the function IIF() in a calculated field:

CalcField: IIF([Forms]![FormName]![FormControl]=True,"ValueTrue","ValueFalse")


I'm not sure if meant you wanted further choices (i.e. a real Select Case...).
If you do, you can nest IIF() statements to achieve this.

Is there a way to do something like an if else so that I can run one of two
selects based on a form field? Something like

IF form!fiield = true
selct ....
else
select....

 

[Guest]

You can use an IIF statement in your criteria of the query.

Post an example of your data and what you would have in the form.
--
KARL DEWEY
Build a little - Test a little

IIF will not work in this case. A query in Access will not let you start with
iif for one and two if you try this is will not let you return more than one
row. I need to do a select if the value is true that will return multiple
rows.

Use the function IIF() in a calculated field:

CalcField: IIF([Forms]![FormName]![FormControl]=True,"ValueTrue","ValueFalse")


I'm not sure if meant you wanted further choices (i.e. a real Select Case...).
If you do, you can nest IIF() statements to achieve this.

Is there a way to do something like an if else so that I can run one of two
selects based on a form field? Something like

IF form!fiield = true
selct ....
else
select....