Save sum of table values to form field

Posted on 2009-04-22
Last Modified: 2012-05-06
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
Question by:samipk
    1 Comment
    LVL 46

    Accepted 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

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Join & Write a Comment

    Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
    Regardless of which version on MS Access you are using, one of the harder data-entry forms to create is one where most data from previous entries needs to be appended to new records, especially when there are numerous fields and records involved.  W…
    In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …
    With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

    745 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now