Display Weight in Lbs and Oz.

[Guest]

I would like to know how I can set it up in a query so that the weights that
I have in one field will be displayed in Lbs and Oz.

So if my weight is 9.21875 Lbs Can the query display the weight as 9Lbs &
3.5 Oz.

Thanks

Keith

 

[Douglas J. Steele]

Int([DecimalWeight]) & " Lbs, " & Format(([DecimalWeight] -
Int([DecimalWeight])) * 16, "00.0") & " Oz."

 

[Guest]

Thanks Douglas!!

Int([DecimalWeight]) & " Lbs, " & Format(([DecimalWeight] -
Int([DecimalWeight])) * 16, "00.0") & " Oz."

--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)

I would like to know how I can set it up in a query so that the weights
that
I have in one field will be displayed in Lbs and Oz.

So if my weight is 9.21875 Lbs Can the query display the weight as 9Lbs &
3.5 Oz.

Thanks

Keith

 

[Guest]

Thanks Ken!!

Keith:

Something like this should do it:

SELECT SomeField, SomeOtherField,
INT([Weight]) & " lbs & " & ([Weight] - INT([Weight]))*16 & " oz"
AS PoundsAndOunces
FROM YourTable;

Ken Sheridan
Stafford, England

I would like to know how I can set it up in a query so that the weights that
I have in one field will be displayed in Lbs and Oz.

So if my weight is 9.21875 Lbs Can the query display the weight as 9Lbs &
3.5 Oz.

Thanks

Keith

 

[John Nurick]

Hi Keith,

Something like this:
Format(Int(w), "0 \l\b\ ") & Format((w - Int(w))*16, "0.00 \o\z\.")