IF and mutliple selects

D

Dale

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

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

Dale

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.

kingston via AccessMonster.com said:
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....
Click to expand...
Click to expand...
 
K

KARL DEWEY

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


Dale said:
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.

kingston via AccessMonster.com said:
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....
Click to expand...
Click to expand...
Click to expand...
 
Top