trying to get a total on a main form from subform info

G

Guest

I have 3 forms: FORM1, FORM2 is a subform in FORM1 and FORM3 is a subform in
FORM2. I have a field named QTY in FORM3 that I would like Summed on FORM1.
In the relationships; TABLE1, TABLE2 and TABLE3 have a field called BOLN.
There is one BOLN in TABLE1 for many BOLN in TABLE3. In the properties of the
forms, Link Child Fields and Link Master Fields all contain BOLN. Hopefully
this isn't too confusing. Thanks in advance.
 
G

Guest

I do it the simple way by creating a totals query and using it joined to my
TABLE1 in the query for the main form.
The totals query has the primary key field and count. It is joined on the
primary key field in the query for the main form.
 

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

Force an empty form to get inserted, in background (without changingfocus, selection, etc.) 2
Duplicate Subform and SubSubForm Records but not Main 1
Problems Linnking a SubForm 4
Filter Field Selection from Previous Field 2
Changing Focus from Subform to Main Form 3
Best way to link popup form? 6
Combo to select form then combo to select field for query 1
One-to-One Table keys 9

Top