Results 1 to 3 of 3
  1. #1
    Join Date
    May 2009
    Posts
    72

    Unanswered: weight calculation

    hi
    iam stuck with an calculation issue

    I have a materialstable which contains material name , density

    I have another table materilalform which contains shape

    I have another table materialweight which contains the following

    material name....lookup from materialstable....value is....steel
    material shape...lookup from materialform.......value is...square
    material size....value I enter is 10x10x10
    how do I compute the weight of the material and fill an unbound box in a form
    I am aware of the technical side of it... that is length x breadth x thickness x density will give me the weight

    but my issue is
    how do I make the vb know that the value entered in the table 10x10x10 (10 ex 10 ex 10) is length breadth and thickness values.

    my design doesn't allow me to allot separate columns for L,B,T in the table


    any help is greatly appreciated

    thanks in advance
    Hemanth RK

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    Without knowing your design it's kind of hard to say.
    Strictly speaking it's the volume x density gives the mass, unless the height, weight and depth are consistent. H x W x D works if the object is a flat faced solid 6 sided box. It doesn't work if the object has voids, irregular surfaces or cut outs or is spherical. Again as we don't know what you are trying to model we can't say.

    The smart aleck reply is if your model doesn't support that sort of data and it should then your data model is flawed.
    I'd rather be riding on the Tiger 800 or the Norton

  3. #3
    Join Date
    May 2009
    Posts
    72
    thanks healdem
    I have rebuilt the data model and working on it
    thanks again

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •