How to display data group by in a subform

  • Thread starter Thread starter Dou
  • Start date Start date
D

Dou

How to display data by group in a subform and display total every group on
the page foot.

Thanks
 
Hello Dou.

Dou said:
How to display data by group in a subform and display total
every group on the page foot.
Click to expand...

In the main form, use a query that contains the field you want to group by.
In the subform, use a query that contains the details including the field
used to group the infotmation.
In properties of the subform control on the main form, set the
LinkChildFields and LinkMasterFields properties. In the footer of the
subform, calculate the desired total.
If you want, you can also display that total in the main form:
=subformcontrol.Form!totalfield
 
Back
Top