USING DSUM IN REPORT

[desikan]

I have a table with following fields : "TYPE","NAME","QUANTITY". Data is available with similiar/dissimiliar types,names and quantities.

I am making a report with grouping based on "type" and under that, another grouping based on "name" and I want the quantities under each name for a particular type to be totalled.

I am using a unbound text box pointing to =DSum("[QUANTITY]","TABLE&quotand I have placed this text box in the "Name header".

But I am getting the total sum of all quantities for each name field ignoring the type and name grouping.

Extremely grateful for any help.

Desikan

 

[desikan]

Well I found answer to my own query. I was using wrongly "DSUM" function instead of "SUM" function.

I used =Sum([QUANTITY]) and I am getting ok

Thanks