Welcome to SPN

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

Sign Up Now!
  1.   Become a Supporter    ::   Make a Contribution   
    Target (Recurring Monthly): $200 :: Achieved: $98

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,
    >
    >
     
Since you're here... we have a small favor to ask...

More people are visiting & reading SPN than ever but far fewer are paying to sustain it. Advertising revenues across the online media have fallen fast. So you can see why we need to ask for your help. Donating to SPN's is vote for free speech, for diversity of opinions, for the right of the people to stand up to religious bigotry. Without any affiliation to any organization, this constant struggle takes a lot of hard work to sustain as we entirely depend on the contributions of our esteemed writers/readers. We do it because we believe our perspective matters – because it might well be your perspective, too... Fund our efforts and together we can keep the world informed about the real Sikh Sikhi Sikhism. If everyone who writes or reads our content, who likes it, helps us to pay for it, our future would be much more secure. Every Contribution Matters, Contribute Generously!

    Become a Supporter      ::     Make a Contribution     



Share This Page