Hi

I'm no expert with reports : I have a query selecting groups of items -
having their own itemID so to speak - I have managed to list these in a
way so that each group of Items is listed in its own "table" in the
report.

[Name] - [Description]- [Price]
Item1 socks 25
Item1  trousers 90
Item1  handkerchiefs 34

Sum

[Name] - [Description]- [Price]
Item2 coffins 334
Item2 tires 626

Sum

......

[Total Sum]

I just want to sum up each of these distinct tables - the price - and
put it in below each of them. I've only managed to sum up the price row
of the entire query - with the DSUM-routine. I recon it should be
possible to take only the Item1-items and sum them up, putting it in
below the first table - and then the Item2 and so forth. Is there a
really easy way to do this? Or would I need to make a recordset of all
the items - and put it into the [criteria]-argument in the
DSum-routine? I know I could make queries to sum up each of them - but
then I would have to make a new query for each new type of ItemID the
user would want to add to the database - if you know what I mean. I
want it to be dynamic.

I would want something like =DSum("[price]";"myQuery";"Where
[nameInQuery] = [nameInReport])

Hope someone is able to help

regards

Vegard