multiple tables report at different levels

[naminder]

Hi

I have finally finished the database but i have a major report I am having trouble with.

I need a report that works in stages for a property building system

At the top is the property type

this has a table property materials showing the materials it is made of, costing

Then property type has property units it is made up of. e.g. house, flats etc

These flats - have rooms e.g. bedroom which has fixtures fittings with costings

basically the report goes down one level for property materials and three levels down for fixtures and fittings

HOW do i get the total costs of the property type as a whole e.g. combine materials, fixtures to give total costs of building it.

Hope this is clear enough, any help appreciated. will stop me getting white hairs!!!

 

[Rovers]

You need to group the report by the different levels and then sum those figures in each group footer.