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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Form Design Recommendation Tab and subforms 4
Required data on subforms 2
Clear the subform 3
Using an option group to display a subform 10
Subform Value Does Not Display in Form (but will in table) 1
Subform Display 1
Subform only showing 1 record instead of all records 6
How to use forms with subforms for data entry? 2

Back
Top