I am Creating a Admindatabase for all my employees. I need a report that shows me all my managers and all employees. I want it to look like this see attachment.




With the Managers going across the top but to automaticly change or add managers if they get promoted. I can lay out text boxes to acomplish the look I want but I am having trouble making the manager boxes update with the next manager in the Quiry.Would it be better to make a FORM for this or is there a VBA or macro I can use?

Thank you for any help you can provide me.

Jeremy

First, welcome to UA!

Second, reports in Access are not made to change data but simply to display data.

Do do what you want to do, it will be far easier to use a form.

OK form works for me, all I need each text box to do is pull the next manager name and place in a manager box then all the employees that report to that manger to be populated under the correct manager. I have quiries built already just not sure how to make the next box recognize the next manager in my list of employees.

What you need are "cascading" boxes.

If you use the wiki you should find great examples or go to:

www.datapigtechnologies.com and dig a round a little.

They have a great video tutorial of how to do exactly what you want.

Im not sure casecading boxes are what I am looking for. I do not want to change any information. I just want to make the report look the way I want it laid out . I want all of my managers to populate along the top Horizontally and my employees to populate Vertically under their corisponding manager. Is there a way to make this happen all I can get on the report is my going veritcally on the left.