L
Les Coover
Access 2000
I have a question about summation fields on a form. I built a form that
has a subform based on 1..* relationship. In the Form Footer of the subform
I sum fields, for example: nz(Sum([myField])) Then in the Detail section
of
the main form I collect the contents, for example:
[subfrmHere].Form![TotalmyField]
No problem here that all works fine, but what I also need to do is put grand
totals
in the Form Footer section of the main form. I don't understand how to do
this.
I settled on another subform based on a query--this works, but it won't
update
unless I close, then reopen the main form.
The better way might be to use an SQL statement in a text box instead of
going
to all the trouble to make a query--subform and place it in the main form
footer.
Anyone have any idea what the syntax would be so that fields would be
updated
as records are added?
Would it be better to use an event VBA procedure?
Suggestions welcomed--any help given is appreciated.
Les
I have a question about summation fields on a form. I built a form that
has a subform based on 1..* relationship. In the Form Footer of the subform
I sum fields, for example: nz(Sum([myField])) Then in the Detail section
of
the main form I collect the contents, for example:
[subfrmHere].Form![TotalmyField]
No problem here that all works fine, but what I also need to do is put grand
totals
in the Form Footer section of the main form. I don't understand how to do
this.
I settled on another subform based on a query--this works, but it won't
update
unless I close, then reopen the main form.
The better way might be to use an SQL statement in a text box instead of
going
to all the trouble to make a query--subform and place it in the main form
footer.
Anyone have any idea what the syntax would be so that fields would be
updated
as records are added?
Would it be better to use an event VBA procedure?
Suggestions welcomed--any help given is appreciated.
Les