Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

how do I add totals in access

Discussion in 'Information Technology' started by aman, Jul 28, 2006.

Tags:
  1. aman

    aman
    Expand Collapse
    Guest

    Urgently need help
    I have various data in one of my form e.g
    Book Name Price
    Bamby £10
    Maps £4
    Access £20

    I want to be able to calculate & view the total price on all items as there
    are over 100 different title in the form.
    does any one know any formula or how I can do so.
     
  2. Loading...


  3. Joseph Meehan

    Joseph Meehan
    Expand Collapse
    Guest

    aman wrote:
    > Urgently need help
    > I have various data in one of my form e.g
    > Book Name Price
    > Bamby £10
    > Maps £4
    > Access £20
    >
    > I want to be able to calculate & view the total price on all items as
    > there are over 100 different title in the form.
    > does any one know any formula or how I can do so.


    Assuming you are using Access database, let's start with a description
    of your table format and continue on what type of grouping do you want
    totaled?

    --
    Joseph Meehan

    Dia duit
     
  4. Ken Sheridan

    Ken Sheridan
    Expand Collapse
    Guest

    If you simply want to total the price field for all records in the form add a
    text box to the form's footer with a ControlSource of:

    =Sum([Price])

    Ken Sheridan
    Stafford, England

    "aman" wrote:

    > Urgently need help
    > I have various data in one of my form e.g
    > Book Name Price
    > Bamby £10
    > Maps £4
    > Access £20
    >
    > I want to be able to calculate & view the total price on all items as there
    > are over 100 different title in the form.
    > does any one know any formula or how I can do so.
    >
    >
     

Share This Page