<div>
&lt;a table called Tbl_Divisions that has DivisionID and Division Total.&gt; 
This table concerns me as tables should not really contain (store) &nbsp;&quot;Totals&quot; 
 
Totals should be calculated in a query. 
 
So basically you would create a query to calculate the totals, (and show the DivisionID) then relate this to the AddressBook table on DivisionID 
 
Then use the report wizard in Access to create a simple report. 
 
See if you can get this far on your own, then report back. 
 
Remember, since you did not post any details on this design, it is difficult fo us to present a tru &quot;Solution&quot; here. 
it is not clear if your tables are properly normalized or related... 
 
 
&lt;I want to put this on a form as a button so it when I click on the button...&gt; 
This is much later, ...lets focus on the table design first, then the report... 
Sound fair? 
 
JeffCoachman
</div>

<div>
 
Ok, here goes: 
Table one is the Tbl_Divisions that has DivisionID and Division Total. &nbsp;The totals is generated from a query and updated to the Tbl_Divisions table. &nbsp;This is used for reporting purposes and as a check point in other parts of the system. 
 
Second I have a table named Tbl_AddressBook that has Division, Cost Center, Emplid, EmpName, Office phone, cell phone, and home phone. 
 
I have a query where I tie both Tbl_Divisions and Tbl_AddressBook together by DivisionID. 
 
I have a report based on this query where it shows the Divisionid,Cost Center and Department Name, 
Then it list in detail the members of the department along with their &nbsp;Emplid, EmpName, Office phone, cell phone, and home phone. 
 
I have been running this report and individually inserting the DivisionID so I am able to print each report manually. &nbsp; 
 
 
What I want to do is use the Tbl_Divisions table DivisionID that list all report groups that I need individual reports for. 
I will have approximately 30 reports. &nbsp;I need to be able to create each report against the DivisionID and save each report as a PDF and as a printed report. 
 
I am looking for code behind the buttons to do this. 
 
Hope that answers the question better.
</div>

<div>
&lt;Table one is the Tbl_Divisions that has DivisionID and Division Total. &nbsp;The totals is generated from a query and updated to the Tbl_Divisions table. &nbsp;This is used for reporting purposes&gt; 
Again, you can use a query for this. 
Using a table for this introduces more issue that it solves. 
 
The bottom line is that you can use a recordset to loop all the DivisionID's then generate a report for each. 
 
As far as I can tell, the solution here is the same as the solution here: 
<a href="https://www.experts-exchange.com/questions/27018331/Using-a-table-to-run-a-query-from-and-writing-each-item-into-a-report.html" rel="ugc">https://www.experts-exchange.com/questions/27018331/Using-a-table-to-run-a-query-from-and-writing-each-item-into-a-report.html</a> 
 
JefFCoachman
</div>

<div>
Jeff, thanks for responding. &nbsp;Ok I am removing the Division totals. &nbsp;The table now has only the DivisionID. &nbsp; 
 
I setup the two tables in a query within the report and need it to extract individual reports by DivisionID. &nbsp;When I have it setup it error's out. &nbsp;Not sure what is causing me trouble. 
Here is the code for the button. 
 
Private Sub CmdButtonRecallRosters_Click() 
On Error GoTo Err_CmdButtonRecallRosters_Click 
 
Dim rst As DAO.Recordset 
Dim strReportName As String 
strReportName = &quot;Rpt_680_RecallRoster&quot; 
Set rst = CurrentDb.OpenRecordset(&quot;SELECT DivisionID FROM Tbl_Divisions&quot;) 
rst.MoveFirst 
 
Do While Not rst.EOF 
&nbsp; &nbsp; DoCmd.OpenReport strReportName, acViewPreview, , &quot;Division=&quot; &amp;&nbsp;rst!DivisionID 
&nbsp; &nbsp; DoCmd.OutputTo acOutputReport, strReportName, acFormatPDF, &quot;C:\&quot; &amp;&nbsp;&quot;Division&quot; &amp;&nbsp;rst!DivisionID &amp;&nbsp;&quot;.pdf&quot; 
&nbsp; &nbsp; DoCmd.Close acReport, strReportName 
&nbsp; &nbsp; rst.MoveNext 
Loop 
 
rst.Close 
Set rst = Nothing 
 
 
Exit_CmdButtonRecallRosters_Click: 
&nbsp; &nbsp; Exit Sub 
 
Err_CmdButtonRecallRosters_Click: 
&nbsp; &nbsp; MsgBox Err.Description 
&nbsp; &nbsp; Resume Exit_CmdButtonRecallRosters_Click 
&nbsp; &nbsp; 
End Sub 

</div>

<div>
Jeff, Thanks for the information and that fixed my problem. &nbsp;I have another question. &nbsp;Still part of this one. 
 
Do you know where I can find the code information for the different codes for the outputformat 
I was given acFormatPDF, I cannot find this anywhere. &nbsp;I want to send the report to a printer. &nbsp;Can you help. 
 
DoCmd.OutputTo acOutputReport, strReportName, acFormatPDF, &quot;C:\&quot; &amp;&nbsp;&quot;Division&quot; &amp;&nbsp;rst!DivisionID &amp;&nbsp;&quot;.pdf&quot;
</div>

<div>
Thanks, Jeff. &nbsp;Great call.
</div>

<div>
<div class="content wysiwyg-content">
Looking for a way to use a table called Tbl_Divisions that has DivisionID and Division Total. &nbsp;A table named Tbl_AddressBook that has Division, Cost Center, Emplid, EmpName, and other information. &nbsp;I need a report created for each line within the Tbl_Divisions by DivisionID From the Tbl_AddressBook. &nbsp;and then total the number of team members and total number of teams from that table. 
 
I want to put this on a form as a button so it when I click on the button it will kick off and create all individual division reports from the Tbl_AddressBook without anyone having to select each one. &nbsp;I would appreciate the help. &nbsp;
</div>
</div>

Looking for a way to use a table called Tbl_Divisions that has DivisionID and Division Total.  A table named Tbl_AddressBook that has Division, Cost Center, Emplid, EmpName, and other information.  I need a report created for each line within the Tbl_Divisions by DivisionID From the Tbl_AddressBook.  and then total the number of team members and total number of teams from that table.

I want to put this on a form as a button so it when I click on the button it will kick off and create all individual division reports from the Tbl_AddressBook without anyone having to select each one.  I would appreciate the help.  

Report Generation in Acess 2007

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.