Sums in report

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

DSum() is very rarely required in reports. To sum Price in a group footer,
use and expression like:
=Sum([Price])
or maybe
=Sum([Price] * [Quantity])

--
Duane Hookom
MS Access MVP
--

"Veggis" wrote in message
ups.com...
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

Thanks ! I'lll try that.