Calculations on report elements

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

faberk - 29 Nov 2004 15:53 GMT

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

Reply to this Message

Duane Hookom - 29 Nov 2004 16:10 GMT

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

Signature

Duane Hookom
MS Access MVP
--

>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
[quoted text clipped - 8 lines]
>
> Thanks

Reply to this Message

faberk - 29 Nov 2004 16:47 GMT

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

> Please provide some information so someone can help you. What are the
> calculations and the "specific records"? DLookup() is rarely required for
[quoted text clipped - 12 lines]
> >
> > Thanks

Reply to this Message

Duane Hookom - 29 Nov 2004 17:48 GMT

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

Signature

Duane Hookom
MS Access MVP
--

> Sorry for being vague. Here is an example of two groups and their detail
> records:
[quoted text clipped - 47 lines]
>> >
>> > Thanks

Reply to this Message