1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Access 2010 - - - Auto Calculate Totals

Discussion in 'Business Applications' started by luvs_kaos, Apr 3, 2012.

Thread Status:
Not open for further replies.
Advertisement
  1. luvs_kaos

    luvs_kaos Thread Starter

    Joined:
    Aug 25, 2007
    Messages:
    42
    So I have created a from in Access to work as a data base and as a Receipt to give out.

    Now I have about 17 fields that I need to be calculated.

    Prior to this, I have been doing this in excel and then copy and paste into Access, this is kind of a pain to keep two separate files and to update two separate files :mad:

    One field I need is "TOTAL PAID"
    My form follows a format as follows

    ITEMS Producer FEE Our FEE
    Item 1 $00.00 $00.00
    Item 2 $00.00 $00.00
    Item 3 $00.00 $00.00
    Item 4 $00.00 $00.00 (I have seven "items" that need to be listed)
    TOTAL $00.00 $00.00 (I want this to auto calculate the "Producer FEES" / And "OUR FEES"

    Then I need a calculation of the grand total of "Total Producer fees" and "Total Our fees"

    I am trying to be clear is possible... I hope that there is someone out there that can help me with this.... :D
     
  2. Rockn

    Rockn

    Joined:
    Jul 29, 2001
    Messages:
    21,189
    Use a report to calculate the totals
     
  3. OBP

    OBP Trusted Advisor

    Joined:
    Mar 8, 2005
    Messages:
    18,834
    I am concerned about your data structure that you have 17 Fields, rather than 17 Records.
    If you had 17 Records you could just total the records in the form's Footer.
     
  4. luvs_kaos

    luvs_kaos Thread Starter

    Joined:
    Aug 25, 2007
    Messages:
    42
    My goal is essentially to create a database that will keep records and primarily act as a receipt book.

    Below is a rough layout of what i need.

    so all of the items in the first circle need to be totaled at the bottom, and as well for the second column...

    then those two totals need to be combined towards the top of the page.

    [​IMG]

    So when I enter the fees i want it to auto calculate the totals, and ultimately print that record out as a customer receipt... and still maintain it as a searchable document.

    is this even possible?
    i didn't really want to create a report every time i need a receipt.

    (I am a beginner at access...clearly...)
     
  5. OBP

    OBP Trusted Advisor

    Joined:
    Mar 8, 2005
    Messages:
    18,834
    The standard way to do what you want is to have at least 2 tables, one for the top section of data ie the Receipt and the second for the items of the receipt.
    The second table is then used as a "Subform" for data entry & display. The subform can then do the calculation and the "result" placed in the "sum of" field.

    Of course to Print the data you should use a Report.
     
  6. Sponsor

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/1047848