Welcome to SPN

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

Sign Up Now!

Calculate field based on many side field value

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

  1. Martino165

    Martino165
    Expand Collapse
    Guest

    Sorry for the horrible analogous DB

    two tables
    "keg"
    "can"

    one to many relationship between keg and can. a single keg could fill
    many cans

    "keg" has fields originial volume and current volume
    I would like the current volume to be the amount left in the keg based
    on the amount poured into individual cans.

    keg.currentvolume = keg.originalvolume - (total volume of cans from
    that keg)

    hope this is enough info..
    thanks,
     
  2. Loading...

    Similar Threads Forum Date
    India Reading Calculated Banis Breaking News Mar 6, 2013
    Canada Huddersfield Sikh community leader Bakhshish Singh Bhullar dies... Breaking News Jan 27, 2014
    The ‘Flying Sikh’ on India’s lamentable track-and-field prowess Sports & Fitness Oct 4, 2010
    India India Can Never Beat China in Any Field Breaking News May 22, 2010
    US Defense Department Hiring Resident Aliens in Medical and Language Fields Business, Lifestyle & Leisure Dec 6, 2008

  3. Tom Wickerath

    Tom Wickerath
    Expand Collapse
    Guest

    Hi Martino,

    Take a look at MVP Allen Browne's sample, and see if you can apply it to
    your situation:

    Inventory Control: Quantity on Hand
    http://allenbrowne.com/AppInventory.html


    Tom Wickerath
    Microsoft Access MVP

    http://www.access.qbuilt.com/html/expert_contributors.html
    http://www.access.qbuilt.com/html/search.html
    __________________________________________

    "Martino165" wrote:

    > Sorry for the horrible analogous DB
    >
    > two tables
    > "keg"
    > "can"
    >
    > one to many relationship between keg and can. a single keg could fill
    > many cans
    >
    > "keg" has fields originial volume and current volume
    > I would like the current volume to be the amount left in the keg based
    > on the amount poured into individual cans.
    >
    > keg.currentvolume = keg.originalvolume - (total volume of cans from
    > that keg)
    >
    > hope this is enough info..
    > thanks,
    >
    >
     

Share This Page