How to structure multiple If/Then statements? (1 Viewer)

[Coach Ty]

Hello,

I need to find out how to structure mutiple If/Then statements?

I would like to base a query on multiple If/Then statements that are listed in sequence.

The answer to the query will be based on multiple True values, that are entered into check boxes.

For example: The answer to a query (A) will be a value based on if several factors have been listed as True in the corresponding check boxes.

I understand how to design a single If/Then statement, for a single check box: A: IIf([__]=True,___)

What I need to do is design the same type of query that will return a value, that is based on multiple True values, using the same check boxes.

Thanks for your help!

 

[georgedwilkinson]

You can nest Iif statements.

Iif (1,Iif(1,"Double True","Single True"),"Not True at all")

I can's say for sure without more information, but it sounds like you have a major design issue. I have designed more databases than I can count and have never had to resort to nested Iif statements in a query.