Calculating Totals

[Guest]

I have one field on a form that is a price and another field which is a
quantity of any number. I want to mutliply these to numbers to find a total.
Do I use expression builder or code builder? and how would I make this
calculation?
Lucy

 

[Rick B]

Just add an unbound field to your form. click it and type in the following
(using your field names)...

=[PriceField] * [[QuantityField]

 

[Guest]

Thank you.
Now I have many totals in sumform and i want to add these totals together on
the main form can this be done?
Lucy

Just add an unbound field to your form. click it and type in the following
(using your field names)...

=[PriceField] * [[QuantityField]



--
Rick B

I have one field on a form that is a price and another field which is a
quantity of any number. I want to mutliply these to numbers to find a
total.
Do I use expression builder or code builder? and how would I make this
calculation?
Lucy

 

[Guest]

Look in the Northwind sample database that ships with Access. See the Orders
form and Orders sub form. It has an excellent example of how to do that.

Thank you.
Now I have many totals in sumform and i want to add these totals together on
the main form can this be done?
Lucy

Just add an unbound field to your form. click it and type in the following
(using your field names)...

=[PriceField] * [[QuantityField]



--
Rick B

I have one field on a form that is a price and another field which is a
quantity of any number. I want to mutliply these to numbers to find a
total.
Do I use expression builder or code builder? and how would I make this
calculation?
Lucy

 

[Guest]

I have been looking at that sample database but im not understanding how
totals have been calculated.

Look in the Northwind sample database that ships with Access. See the Orders
form and Orders sub form. It has an excellent example of how to do that.

Thank you.
Now I have many totals in sumform and i want to add these totals together on
the main form can this be done?
Lucy

Just add an unbound field to your form. click it and type in the following
(using your field names)...

=[PriceField] * [[QuantityField]



--
Rick B



I have one field on a form that is a price and another field which is a
quantity of any number. I want to mutliply these to numbers to find a
total.
Do I use expression builder or code builder? and how would I make this
calculation?
Lucy

 

[Guest]

In the sub form there is a text box named Extended Price. It gets its value
from a calculation in the record source Order Details Extended.

In the footer of the sub form, there is a text box named OrdersSubtotal. It
has a control source of =Sum([ExtendedPrice])
Which will add up ExtendedPrice on the subform

Then on the main form, the text box Subtotal has as its control source
=[Orders Subform].Form!OrderSubtotal which is the same as OrdersSubtotal.
You can see in the query Order Details Extended how the calculation is done
for each line item. Then the controls on the forms do the rest of the
calculation.

It will be the same as the OrdersSubTotal

I have been looking at that sample database but im not understanding how
totals have been calculated.

Look in the Northwind sample database that ships with Access. See the Orders
form and Orders sub form. It has an excellent example of how to do that.

Thank you.
Now I have many totals in sumform and i want to add these totals together on
the main form can this be done?
Lucy

:

Just add an unbound field to your form. click it and type in the following
(using your field names)...

=[PriceField] * [[QuantityField]



--
Rick B



I have one field on a form that is a price and another field which is a
quantity of any number. I want to mutliply these to numbers to find a
total.
Do I use expression builder or code builder? and how would I make this
calculation?
Lucy