View Single Post
  #1  
Old May 13th, 2010, 10:28 PM posted to microsoft.public.access.reports
Stacey Crowhurst[_2_]
external usenet poster
 
Posts: 88
Default SubReport Field / Report Field = %

Hi! I have a report [rptProjectedCostSummaryFinal] with a subreport
[rsubCauseCodeAllocation].

The report is like so....
Details details details $$$$$$
Details details details $$$$$$
Total Budget Total Committed Total Uncommitted Total Projected Total
Variance

The subreport is like so...
CauseCodeDesc Amount
1. Base Scope $50,000
2. Stakeholder $500
3. Error & Omission $2,000
4. Job Field $675
Total $53,175

What I want to happen is for each of the four cause codes to show what
percentage each is of the total projected costs like so...
CauseCodeDesc Amount
1. Base Scope $50,000 80%
2. Stakeholder $500 1%
3. Error & Omission $2,000 3%
4. Job Field $675 1%
Total $53,175

How do I create a text box with a percentage formula of [subreport amount] /
[report amount]? Please let me know what other information you need. I
appreciate your help!

Thanks!
Stacey