Managing Patner

Hankwembo Christopher,FCCA,FZICA,CIA,MAAT,B.A.Sc

<div>
But I do not want the stuff in the details report to appear how do I hide them???????<br />
<br />
Regards<br />
<br />
Chris
</div>


But I do not want the stuff in the details report to appear how do I hide them???????

Regards

Chris

<div>
<div class="content wysiwyg-content">
Hi<br />
<br />
We need to calculate the final payroll Journal, unfortunately the figures for PAYE has to come from the extensive and complicate cumulative basis calculations. Now all I want here is to find out the following:<br />
<br />
(1) &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;How to put the Salary journal report consolidating all the PAYE by staff in the report footer<br />
(2) &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Hide the detail part which shows calculation by staff, so that when printing only the staff on the report footer should show.<br />
(3) &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;The details part of the report will have all the calculations for the staff to supply the footer report or act as the recordset but must be hidden so that only the report footer shows only.<br />
<br />
Regards<br />
<br />
Chris<br />
<a href="https://filedb.experts-exchange.com/incoming/2019/11_w46/1436680/Payrollsummary.png" target="_blank" title="Payrollsummary.png (43 KB)"><img alt="Payrollsummary.png" class="file-block lazyload" style="max-width: 800px;" data-src="https://filedb.experts-exchange.com/incoming/2019/11_w46/800_1436680/Payrollsummary.png" /></a>
</div>
</div>


Payrollsummary.png

Hi

We need to calculate the final payroll Journal, unfortunately the figures for PAYE has to come from the extensive and complicate cumulative basis calculations. Now all I want here is to find out the following:

(1)	How to put the Salary journal report consolidating all the PAYE by staff in the report footer
(2)	Hide the detail part which shows calculation by staff, so that when printing only the staff on the report footer should show.
(3)	The details part of the report will have all the calculations for the staff to supply the footer report or act as the recordset but must be hidden so that only the report footer shows only.

Regards

Chris


How to use the report footer in Ms access

Act! (previously known as Sage ACT!) is a customer relationship management (CRM) software application which is used to keep track of client and prospect details in a single database that can be shared by multiple users. Act! features include contact, company and opportunity management, a calendar, communication tools, the ability to track prospective customers, "dashboards", reports, and the ability to synchronize data from other applications or other Act! users over the web.

A printer is a peripheral which makes a persistent human readable representation of graphics or text on paper or similar physical media. Traditional printers are being used more for special purposes, like printing photographs or artwork, and are no longer a must-have peripheral; 3D printing has become an area of intense interest, allowing the creation of physical objects. An image scanner is a device that optically scans images, printed text, handwriting, or an object, and converts it to a digital image. Hand-held scanners, where the device is moved by hand, have evolved from text scanning "wands" to 3D scanners used for industrial design, reverse engineering, test and measurement, orthotics, gaming and other applications.

Printers and Scanners

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.