• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 226
  • Last Modified:

Save sum of table values to form field

I have a table which has 2 fields named Value and Volume which stores values in number format
I have 1 form which has 2 text fields
1. Total Volume
2. Total Value

I have the record source of the form set to a query which takes the sum of Volume and i then show this result in the total Volume text field

what i want to do is take the total sum of the Value field from the table and show it in the Total Value field in the form..............i then also want to take the Total Value and divide it by Total Volume
1 Solution
Hi samipk,

Add sum(value) to your query & show that in your form
Add a text box to your form with controlsource =[Total Value]/[Total Volume]
where Total Value and Total Volume are the names of the textboxes in your form

Good Luck!


Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now