Summing three levels in ASP

[Marco Alting]

Hi

I have three levels of cost items, like the following:

TOP_LEVEL
SECOND_LEVEL
cost_item1
cost_item2
etc...
TOP_LEVEL2
SECOND_LEVEL2
cost_item3
cost_item4
etc...
etc..

Now I want to total all the cost_items in the SECOND_LEVEL and total all
the SECOND_LEVELs in the TOP_LEVEL. The values come from multiple tables in
ACCESS. I've made this working using queries in access, but now I need to
use a variable from an HTML form that selects a subset of cost_items, I can
make that work for the query of the cost_items, but it has to go through to
the levels above (which works fine in access). My idea now is to only use
the cost_items query and then loop through the values in ASP generating
arrays with the totals.

Does anyone have any clue what I'm on about here? And can you help me out
with examples???

Thanks,
Marco