IIF Statement

[TallMan]

Hello,

Is there a way to not have the "False" part of the IIF statement not populate in a query?

For instance I want all new accounts with yesterdays daye to populate and if it is not yesterdays date I do not want to see it.


Thanks Guys!

 

[Mike375]

Put Null for the false or second part

 

[KenHigg]

I may be missing something but couldn't you just use that expression and abandon the whole iif():

pseudo: = yesterdays date

???

 

[TallMan]

If I put null then I receive every row of accounts that the open date was not yesterday.

 

[Mike375]

You put Is Not Null in the criteria

 

[TallMan]

Duh!!! Thanks Mike375 =)

 

[Chrisopia]

I think a switch statement is like an IIF statement without the false end

 

[TallMan]

Chris,

What is the function for a switch statement?

Do you have any links that could instruct me on this?

 

[Chrisopia]

Well an IIF is made up of

=IIF(Expression, true, false)

Switch is just simply

=Switch (expression, variable)

I find switch particularly useful if many instances are involved, e.g.

=switch([sky]="clear","blue",[sky]="night","black")
(for example, off the top of my head)


It's laid out exactly like your iff statment, except you remove the last "false" statement - and swap "IIF" with "switch"

 

[KenHigg]

Here's a link with several logic methods:

http://www.functionx.com/vbaccess/Lesson06b.htm

 

[TallMan]

Great thanks guys!