S sheederj Registered User. Local time Today, 10:07 Joined Jul 26, 2001 Messages 27 Aug 11, 2003 #1 I need to convert grams in a query to pounds and ounces as two separte values. I am not a visual basic programmer, so does anyone know of a way to do this without programming? Thanks! -J
I need to convert grams in a query to pounds and ounces as two separte values. I am not a visual basic programmer, so does anyone know of a way to do this without programming? Thanks! -J
Mile-O Back once again... Local time Today, 10:07 Joined Dec 10, 2002 Messages 11,305 Aug 11, 2003 #2 For Pounds: Pounds: Int(([WeightInGrams]/28.35)/16) For Ounces: Ounces: Int(([WeightInGrams]/28.35) Mod 16)
For Pounds: Pounds: Int(([WeightInGrams]/28.35)/16) For Ounces: Ounces: Int(([WeightInGrams]/28.35) Mod 16)
