Results 1 to 4 of 4
  1. #1
    3 Star Lounger MacroAlan's Avatar
    Join Date
    Feb 2003
    Location
    St Louis, Missouri, USA
    Posts
    254
    Thanks
    6
    Thanked 1 Time in 1 Post

    Baby's Weight (2003/SP1)

    I am renovating a database where the previous developer limited weights to whole pounds (no decimals). This is fine for adults but babys
    Alan

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Baby's Weight (2003/SP1)

    Can't you switch to metric? That would make things much easier.

    If not, using separate fields for pounds and ounces is probably the best way, especially if you want to be able to enter weights that way.

  3. #3
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Baby's Weight (2003/SP1)

    Alan

    Hans has probbaly answered this before but I would suggest two combo's one for Pounds and the other for ounces.

    You have probably worked this out already but the problem comes when you are wanting to find averages as an aggragate and will have some serious implications.

    IMO I think the best thing to do in the query running your form is to convert the pounds to ounces and then add the them together.

    Therefore Baby A was 6 lb 8 oz= (6x16)+8 =104 oz

    You could use a function like this to calculate the aggregate afterwards.

    Function convertounces(unit_ounce) As String
    Dim pounds As Integer
    Dim ounces As Integer
    pounds = Int(unit_ounce / 16)
    ounces = unit_ounce - (pounds * 16)
    convertounces = pounds & "lb." & " " & ounces & "oz."
    End Function
    Jerry

  4. #4
    3 Star Lounger MacroAlan's Avatar
    Join Date
    Feb 2003
    Location
    St Louis, Missouri, USA
    Posts
    254
    Thanks
    6
    Thanked 1 Time in 1 Post

    Re: Baby's Weight (2003/SP1)

    Thanks guys, Jezza's way seems best for my customers.

    Nobody has heard of metric back in the hills; except that their tools won't work on foreign cars in the front yard.
    Alan

Posting Permissions

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