Summary/Totals report help

[Martin Schmid]

I have three tables, essentially as follows

WORK_PACKAGES[WP_ID,WP_DESCRIPTION]
RESOURCES[RESOURCE_ID,RESOURCE_NAME,RESOURCE_RATE]
WP_RESOURCES[WP_ID,WP_RESOURCE_ID,WP_RESOURCE_HOURS]

RESOURCES is a list of 7 resources, and their rates.
WORK_PACKAGES are a list of tasks.
WP_RESOURCES is a list of resources per task, keyed to the WP_ID

I want a report that has the following format:

Work Package Description (i.e. WP_ID=1.1.1)
Resource, Hours, Rate (Hours * Rate) (repeating field for each
utilized resource)

Work Package Description(i.e. WP_ID=1.1.2)
Resource, Hours, Rate (Hours * Rate) (repeating field for each
utilized resource)
Work Package Description(i.e. WP_ID=1.2.1)
Resource, Hours, Rate (Hours * Rate) (repeating field for each
utilized resource)
Work Package Description(i.e. WP_ID=1.2.2)
Resource, Hours, Rate (Hours * Rate) (repeating field for each
utilized resource)

Resource, Hours (repeating field for all resources showing totals
per WP_ID prefix, i.e., 1)

Work Package Description (i.e. WP_ID=2..x.x)
Resource, Hours, Rate (Hours * Rate) (repeating field for each
utilized resource)


Resource, Hours (repeating field for all resources showing totals
per WP_ID prefix, i.e., 2)

Etc.

Grand Totals:
Resource, Hours




Each work package is ID'd as follows:
1.1.1
1.1.2
1.2.1
1.2.2
2.x.x
3.x.x etc...

Thanks for any insights into creating this.