Sample Project
Effective Microsoft Access Report Modification Services
4 Hour Project
Project to Modify Report in Existing Db
A small contracting company in North Carolina sent over this pdf to our Request a Quote form, asking what it would cost to modify a report in an existing database. They no longer had contact with the original programmer. We did a quick gotomeeting call to go over the database and the requirement. To achieve what the client wanted, we needed to add a field to a table and a form, modify a few queries, and add the field to the report. They were so worried about finding a professional Access resource, and so happy with the customer service we provided, the reasonable price, and the quality work.
Additional details — Client requirements
A general contracting company in North Carolina contacted AccessDeveloper.net to update their invoice report. The existing rptInvoice worked well for years, but new billing requirements demanded additional line-item fields, tax breakdowns, and a revised company header.
- Add JobNumber and PONumber fields to the invoice header.
- Show labor hours and material costs as separate line-item categories.
- Calculate state tax (NC 4.75%) and county tax separately.
- Include updated company logo and revised payment terms footer.
- Export to PDF with auto-generated filename: Invoice_[InvoiceNum]_[Date].pdf
Additional details — Our approach
- Query update:Modified qryInvoiceDetail to JOIN tblJobs for JobNumber and PONumber. Added calculated columns for LaborTotal and MaterialTotal using IIf on Category field.
- Report layout:Opened rptInvoice in Design View. Added text boxes in the Report Header for new fields. Created a Group Footer for tax calculations.
- Tax logic:Added expressions: =Sum([LineTotal]) * 0.0475 for state tax and =Sum([LineTotal]) * [CountyTaxRate] for county tax pulled from tblSettings.
- PDF export:Updated the btnPrintInvoice VBA to use OutputTo with dynamic filename: 'Invoice_' & Me.InvoiceNum & '_' & Format(Date, 'yyyymmdd') & '.pdf'
- Testing:Generated 10 test invoices against historical data and compared totals with manual calculations.
Additional details — Database objects involved
- tblJobs — source for JobNumber and PONumber.
- tblSettings — county tax rate lookup.
- frmInvoice — data-entry form updated for new header fields.
- qryInvoiceDetail — query driving report line items and totals.
- rptInvoice — report layout, grouping, and tax footer.
- btnPrintInvoice — VBA module for PDF export naming.
Additional details — Outcome
The updated report was deployed within 4 hours. The client's accounting team verified all tax calculations matched their CPA's expectations. PDF auto-naming eliminated manual file renaming, saving approximately 30 minutes per billing cycle.
Additional details — When this type of project makes sense
Report modifications are a common request when a business outgrows an existing layout, changes tax rules, or loses contact with the original developer. Similar work often includes adding subreports, grouping changes, custom filters, branded headers, and automated PDF or email output.
- You have a working Access database but need one or more reports updated.
- You lost contact with the original developer and need a safe second opinion.
- Your team has a PDF or paper example of how the output should look.
- You want a fixed quote before any changes are made to production data.
Related resources
Need a similar fix?
Describe your report or database change and a senior Access developer will respond with a free quote — usually the same day.
Request a free quote