Calculations on report elements

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a report that contains groups with headers and footers. In the
report's footer, I wish to insert calculations based on specific records in
the report. I can identify the records in the report's recordset by the
codes they contain. Do I have to use DLookup function to return this
information from the report's recordset? If I do, what "domain" do I use?.
Im unsure how to return the information I need using this function, for only
the records in the report's recordset...

Thanks
 
Please provide some information so someone can help you. What are the
calculations and the "specific records"? DLookup() is rarely required for
this.
 
Sorry for being vague. Here is an example of two groups and their detail
records:

Direct Labour Headcount (report group 1):
ChildId Descr Jan Feb
27 Heavy Duty Repair 3 3
22 Painter 23 23
15 Sheet Metal Worker 75 75

Within this group i wish to sum the Painters and the Sheet Metal workers for
each month

Direct Labour Wage Rates (report group 2):
ChildId Descr Jan Feb
28 Heavy Duty Repair 23.21 23.21
23 Painter 22.16 22.16
16 Sheet Metal Worker 20.45 21.95

Within this group i wish to average the wage rate of Painters and the Sheet
Metal workers for each month

REPORT FOOTER:

I wish to calculate the labour dollars for each group and class:

Headcount x wage rate. Can I do this in the report using formulas, or do i
need to do this in a sub-report?


Thanks for you time
 
Do you have a value stored in a table that groups Painters and Sheet Metal
workers together? If not, I would add one so the solution becomes data
driven.

Descr Category
Heavy Duty Repair 1
Painter 2
Sheet Metal Worker 2
Computer Geek 0
 
Back
Top