Find Jobs
Hire Freelancers

Access Report Problem - Calculated Fields From SubReports Not Transferring Correctly to Main Report

$30-100 USD

In Progress
Posted almost 14 years ago

$30-100 USD

Paid on delivery
I have built a database to handle billing. The Actual bill is one report, with 5 sub reports. The main bill has a summary sheet at the beginning and then lists the details of the 5 sub reports. I'm having problems getting the subreport total for Ins-A to pull through accurately. On the subreport it shows the correct total, but when it goes to the main report, the total is incorrect. It seems like the main form populates the field before it actually finishes calculating the total on the subreport. If you go to the main menu, and then click on INvoice Processing and then on Process INvoices, select Lakeshore and April. Then the DB runs through some calculations and should show the bill (it is a bit slow). You'll be able to see the correct total on the subreport rptBillingInvoicingPreviewInsA, but when it pulls onto rptBillingInvoicingPreviewMain, it doesn't show the correct amount in the summary at the top. ## Deliverables 1) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No 3rd party components unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the worker's Worker Legal Agreement). 2) The reports rptBillingInvoicingPreviewMain, rptBillingINvoicingFinalizedMain, and rptBillingINvoicingHistoricalMain will show the correct subtotals for all subreports, in particular the Ins-A reports. ## Platform Windows XP, Access 2007
Project ID: 3507778

About the project

3 proposals
Remote project
Active 14 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
See private message.
$85 USD in 3 days
4.9 (50 reviews)
5.4
5.4
3 freelancers are bidding on average $84 USD for this job
User Avatar
See private message.
$85 USD in 3 days
5.0 (31 reviews)
4.8
4.8
User Avatar
See private message.
$80.75 USD in 3 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
United States
3.0
3
Member since Jun 16, 2010

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.