Query/Report help

[Guest]

I am creating a report with multiple subreports for a roofing material
database. Each subreport is a category for different products for the reason
that all products have different formulas to figure $sqft. For example there
is an adhesive subform and a membrane subform. Each product is designated to
a particular roof A or B.

Subform#1
Roof Des Category $Sqft
A Adhesive .22
B Adhesive .15


Subform #2
Roof Des Category $Sqft
A membrane .44
B Membrane .32



Total= sum of all $sqft

The problem is i need it to look like this:

Subform#1
Roof Des Category $Sqft
A Adhesive .22
A Membrane .44

Total= A $Sqft


Subform #2
Roof Des Category $Sqft
B Membrane .32
B Adhesive .15

Total= B $Sqft

Ideas??
Thanks

 

[Guest]

Matt:

A simple way would be to dump your calculated subform/report data into a
temporary table. Something like this:

tblTemp
RoofType
Category
SqFtCost

Then create your subreports from the table data, which will allow you to
group by RoofType.

HTH

Sharkbyte

 

[Guest]

thanks

Matt:

A simple way would be to dump your calculated subform/report data into a
temporary table. Something like this:

tblTemp
RoofType
Category
SqFtCost

Then create your subreports from the table data, which will allow you to
group by RoofType.

HTH

Sharkbyte