# Thread: Baby's Weight (2003/SP1)

1. ## 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

2. ## 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. ## 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

4. ## 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.

#### Posting Permissions

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