Calculations on report elements

F

faberk

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
 
D

Duane Hookom

Please provide some information so someone can help you. What are the
calculations and the "specific records"? DLookup() is rarely required for
this.
 
F

faberk

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
 
D

Duane Hookom

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
 
Top