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

Difficult mathematic calculations

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

  1. Levans digital

    Levans digital
    Expand Collapse
    Guest

    I need some serious help please coders!!!
    I have 4 fields as listed below.
    Keep in Mind 1 Cubic Feet = 50 pounds

    Pounds (Number field)
    Cubic Feet (Number field)
    Calculated pounds (Calculated field)
    Caculated cubicfeet (Calculated Field)

    The form would look like this

    Pounds Cubic feet CalLBS CalCF
    50 1 50
    200 3 200
    150 5 5

    Here is what I want to accomplish with my cargo Management Database.
    Ex in Line 1. When 50lbs is entered and 1 cubic feet is entered both values
    are equal so I want the pounds results be reflected in the calculated pounds
    field.

    Ex in Line 2. When 200lbs is entered and 3 cubic feet is entered. Logically
    200 pounds is greater than 3 cubic feet (3 cubic feet x 50 would equal only
    150lbs) therefore again the results must be reflected in the calculated
    pounds field.

    Ex in Line 3. When 150lbs is entered and 5 cubic feet is entered. Logically
    5 cubic feet is greater than 150LBS (5cubic feet x 50 would equal 250LBS)
    Therefore now would the greater value be reflected in the calculated cubic
    feet field.

    I hope you can understand my explanation thanks.
    Please Help
     
  2. Loading...


  3. OP
    Rick B

    Rick B
    Expand Collapse
    Guest

    STOP POSTING THIS. You have now posted this same question at least five
    times.

    Someone will answer you. No need to keep posting over and over in multiple
    newsgroups.

    http://www.mvps.org/access/netiquette.htm



    --
    Rick B



    "Levans digital" <Levansdigital@discussions.microsoft.com> wrote in message
    news:C80140AA-BC75-47E1-90DB-F84174054194@microsoft.com...
    >
    > I need some serious help please coders!!!
    > I have 4 fields as listed below.
    > Keep in Mind 1 Cubic Feet = 50 pounds
    >
    > Pounds (Number field)
    > Cubic Feet (Number field)
    > Calculated pounds (Calculated field)
    > Caculated cubicfeet (Calculated Field)
    >
    > The form would look like this
    >
    > Pounds Cubic feet CalLBS CalCF
    > 50 1 50
    > 200 3 200
    > 150 5 5
    >
    > Here is what I want to accomplish with my cargo Management Database.
    > Ex in Line 1. When 50lbs is entered and 1 cubic feet is entered both
    > values
    > are equal so I want the pounds results be reflected in the calculated
    > pounds
    > field.
    >
    > Ex in Line 2. When 200lbs is entered and 3 cubic feet is entered.
    > Logically
    > 200 pounds is greater than 3 cubic feet (3 cubic feet x 50 would equal
    > only
    > 150lbs) therefore again the results must be reflected in the calculated
    > pounds field.
    >
    > Ex in Line 3. When 150lbs is entered and 5 cubic feet is entered.
    > Logically
    > 5 cubic feet is greater than 150LBS (5cubic feet x 50 would equal 250LBS)
    > Therefore now would the greater value be reflected in the calculated cubic
    > feet field.
    >
    > I hope you can understand my explanation thanks.
    > Please Help
    >
     
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