Progress Report

  • Thread starter Thread starter Brian T
  • Start date Start date
B

Brian T

I am trying to develop a Progress Report that has several work items listed.
For example:

Line Element % of Job % This Period %Cumulativ
-----------------------------------------------------------------------------------
1 Demo 10% 8%
8%
2 Grading 50% 25%
25%
3 Construct 40% 1%
1%

I would like to have the % Cumulative calculated from the previous value
plus the current % This Period amount.

Thanks for any help.
 
You will either need to use joined queries or subqueries to show the
percentages.
If you post your table structure with field names and datatype and include
sample data someone can suggest how to accomplish the queries.
 
Here is my table structure:

ID Autonumber
ProjectNumber Text
ReportNumber Number
Description Text
%TotalofJob Number
%CompletethisPeriod Number
 
Back
Top