TextBox Calculation of Form

[Guest]

Hi,

please Help!! i am struggling. i have a form that has a sub form which shows
the relavent info for quoted jobs. the available viewable fields are:
Description
CostPrice
SalesPrice
ExtendedPrice
Quantity.
on the same form, i have added a text box to sum the value of the Extended
price to give me a total price. the information is taken from a textbox in
the subform summing ExtendedPrice. when i then view the forms sub form, i see
an extra field with the summed value that my text box can retrieve the
information.

i need 1 other text box to retrieve related info.
CostPrice*Quantity. i can do this but it will not sum. i get "#Error"

i have tried lots of things. Queries which show ALL information!! i can get
the subform to show Cost*Quantity without a sum but thats it.

any ideas on how i can get a textbox to calculate this?

Regards,

Nigel

 

[G. Vaught]

When placing a field on a main form that uses values from a subform, you
must precede the subform field name with the mainform name. Such as
Forms!frmOrder!subformname.fieldname.

If you are placing the calculation on the subform, then the calculated
field, must show in a footer area and not in your detail area.

 

[Guest]

Hi Nigel,

To add a bit to G. Vaught's answer, try my tutorial on this subject:

Displaying Subtotals and a Grand Total on a Form
That Displays a One-to-Many Relationship
http://www.access.qbuilt.com/html/subtotals.html


Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________