How do I set up calculating fields on forms, on reports.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to have fields that calculate totals on my form. e.g Field [Qty]
Field [price] Field to show total.

In Paradox I think I created afield with sum[Qty]:[Price] but that was
years ago.

Also need to total columns in reports
 
In the Detail section of your form, you could add a text box and set its
Control Source property to:
=[Qty] * [Price]

If you wanted to total, you could put a text box in the Form Footer section,
and set Control Source to:
=Sum([Qty] * [Price])

It might be better to create a query and put the calculated field there. For
an example of how to do that, open the Northwind sample database, and see
how the Order Details subform gets the data from the Order Details Extended
query.
 
Back
Top