P
public power
I have been working of this for a bout 2 weeks and can't get it right. I have
a form linked to a table(Electric Projects). On this form I have a
subform(Materials Details Subform). The subform has 5 fields(Partno,
Item,Cost, Quantity, Extended), the partno is a combobox that looks up the
partno from a linked table(inventory) and returns the partno, item
description and the cost of the part. I enter the quantity and the extended
box calculates the total price ([Cost]*[Quantity]).
Each project will have several records in the subform, 1 for each part used.
They are linked to the main project by a field (ProjectID)
This all works fine at this point, but I have a Subtotal in the footer of
the subform with the control "=[Quantity]*[Cost]", and all it returns is the
extended value for the current record. I need the total for all records with
the same ProjectID. Can anyone HELP!
a form linked to a table(Electric Projects). On this form I have a
subform(Materials Details Subform). The subform has 5 fields(Partno,
Item,Cost, Quantity, Extended), the partno is a combobox that looks up the
partno from a linked table(inventory) and returns the partno, item
description and the cost of the part. I enter the quantity and the extended
box calculates the total price ([Cost]*[Quantity]).
Each project will have several records in the subform, 1 for each part used.
They are linked to the main project by a field (ProjectID)
This all works fine at this point, but I have a Subtotal in the footer of
the subform with the control "=[Quantity]*[Cost]", and all it returns is the
extended value for the current record. I need the total for all records with
the same ProjectID. Can anyone HELP!