IIF statement in a Report??

[Lmens]

Hello,

I have a query with revenue data grouped by month and by director. I’m building reports for each of the director. I don’t want run separate queries for each of the directors because some of the director’s revenue is spread among other directors based on a certain percentage. I want to be able to display a director’s revenue and also a percentage of the other directors whose revenue is shared in an unbound calculated field. Can I use an “IIf” in the control source to select for example, just rev. for John?

Please help!

Thanks!

 

[statsman]

The short answer is yes you can. However, by doing this you are opening yourself up to a world of problems.
I would create a query with option of selecting the director you wish to print.

 

[Lmens]

Thank you for replying. Please can you direct me on how to do that? Do I create the query with option of selecting a director in the report?

I do appreciate your time.