<div>
Create a Select query joining the MgrID in the Manager table to the MgrID in the Employee table and make this the recordsource for the report.<br />
<br />
Then in the report, Group by Manager and list each employee name.<br />
<br />
mx
</div>


Create a Select query joining the MgrID in the Manager table to the MgrID in the Employee table and make this the recordsource for the report.

Then in the report, Group by Manager and list each employee name.

mx

<div>
I have the report set up in the Grouping/Sorting as this:<br />
<br />
tblMgf.MgfName in the Field and Sort Ascending.<br />
<br />
and i have the tblMgr.MgrName and tblEmp.EmpName as fields on the report. it will list everything in order but keep repeating the mgrname
</div>


I have the report set up in the Grouping/Sorting as this:

tblMgf.MgfName in the Field and Sort Ascending.

and i have the tblMgr.MgrName and tblEmp.EmpName as fields on the report. it will list everything in order but keep repeating the mgrname

<div>
I got it set straight i forgot to add the group header thanks so much
</div>


I got it set straight i forgot to add the group header thanks so much

<div>
You are most welcome. &nbsp;<br />
<br />
mx
</div>


<div>
<div class="content wysiwyg-content">
I have two tables, a Manager table and a Employee table and I want to make a report that will List each managers name and underneath that list every employee related to this manager. 
</div>
</div>


I have two tables, a Manager table and a Employee table and I want to make a report that will List each managers name and underneath that list every employee related to this manager. 

List From Two Tables

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Microsoft Access

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.