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!

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.

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.