Dsum() in Group Footer

  • Thread starter Thread starter Alain
  • Start date Start date
A

Alain

Hi to All,

Is it possible to use the Dsum() fonction in a group footer, I have tried it
and it work just fine but it give me the total of all my recordset based on
the criteria in my formula no matter where I place the control,

I have a report that is divided by group and I need my totals to be split
based on a criteria that is Yes/No control, meaning that if my land is
surplus then I a sum of it , if it is not s ausplus then I make another sum
of it. So, my question is , can the Dsum() can do the job by adding a
grouping function in the criteria section or is there another solution that
I can use beside creating 2 subreport to get the same results??

Thanks

Alain
 
Alain,

If you want to sum a field over the group, just put a control in the groups
footer and set its control source. You don't have to use DSUM.

Control Source: =SUM([YourFieldName])

HTH
Dale
 
Back
Top