R
Richard
Hi,
I have shipping form with subform that creates one record per lot (product
group) to be used within one shipping entry. On the subform I use a
calculated control to sum the product used within the lot to get a record/lot
total. Since one shipping entry can have multiple records/lots I need to sum
the value of these calculated controls from the sub form to display a grand
total on the main form.
I found this article and it says the following:
http://office.microsoft.com/en-us/access/HP051879091033.aspx
"If you want to use the value from a calculated control when computing a
total, you can't use the name of the control in the Sum function. Instead,
you can define the expression in the form's underlying query or SQL statement
and use the name of the calculated field in the Sum function."
Is this the best way to sum the values from the calculated controls on the
subform and if so how do I create this underlying query/sql statement? And
if not what would be the best way to solve this problem?
Also I am new to Access 2007, so the more basic the solution the better.
Thanks!
Rick
I have shipping form with subform that creates one record per lot (product
group) to be used within one shipping entry. On the subform I use a
calculated control to sum the product used within the lot to get a record/lot
total. Since one shipping entry can have multiple records/lots I need to sum
the value of these calculated controls from the sub form to display a grand
total on the main form.
I found this article and it says the following:
http://office.microsoft.com/en-us/access/HP051879091033.aspx
"If you want to use the value from a calculated control when computing a
total, you can't use the name of the control in the Sum function. Instead,
you can define the expression in the form's underlying query or SQL statement
and use the name of the calculated field in the Sum function."
Is this the best way to sum the values from the calculated controls on the
subform and if so how do I create this underlying query/sql statement? And
if not what would be the best way to solve this problem?
Also I am new to Access 2007, so the more basic the solution the better.
Thanks!
Rick