Using IIF? (1 Viewer)

[galvinjaf]

Good Morning,

If I am understanding what IIF does, then I'd like to know how I can use it. I'd like to have a criteria in my query that says, If the input you typed in is the matches the name of a manager, then return the list of dates with JUST that manager. If you don't type in the name of the manager, then return the entire query with all of the managers names and dates.

Does this make sense? I just don't know how to go about setting this up.

 

[pbaldy]

I'd probably use this method:

http://access.mvps.org/access/queries/qry0001.htm

 

[galvinjaf]

This works great. One thing, and I'm sure it's simple, but it's giving my a window to put in my criteria, but I'd like to change what displays as '[Forms]![myForm]![myControl] OR [Forms]![myForm]![myControl] Is Null' and instead have it actually ask 'Manager'...I bascially just want to change the caption?

Attached is an example....

 

[pbaldy]

The intention was that you use a form to gather the user input, and change that to your form/textbox names. If you want to use an input box, try

[Enter Manager] OR [Enter Manager] Is Null

Most of us always use forms to gather input, as you have more control.

 

[galvinjaf]

After reading your post, I now get what you're saying. Self teaching myself. thanks for your help! This worked.

 

[pbaldy]

Happy to help!