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

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
 
A

Allen Browne

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top