Welcome to SPN

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

Sign Up Now!

Difficult Mathematical Calculations please help

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. 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:B2EA5177-35A3-4C3A-AA61-ADC2031E3913@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
    >
     
  4. Douglas J Steele

    Douglas J Steele
    Expand Collapse
    Guest

    I'm assuming Pounds, Cubic Feet, CalLBS and CalCF are fields on a form: you
    don't store calculated values in tables.

    For CalLBS, try:

    IIf(Me.Pounds*50 >= Me.[Cubic feet], Me.Pounds*50, "")

    For CalCF, try:

    IIf(Me.Pounds*50 >= Me.[Cubic feet], "", Me.[Cubic feet])

    --
    Doug Steele, Microsoft Access MVP
    http://I.Am/DougSteele
    (no e-mails, please!)


    "Levans digital" <Levansdigital@discussions.microsoft.com> wrote in message
    news:B2EA5177-35A3-4C3A-AA61-ADC2031E3913@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
    >
     

Share This Page