Number conversion to pounds - ounces 2

[BusMgr]

In me report, I need to output pounds & ounces from a decimal number, ie 5 pounds 8 ounces from 5.5 pounds. I input pounds and ounces separatly on my form, convert them to decimal, do all my calculations and summing, but can't figure out the way to display it back to pounds and ounces.

Thanks for your help in advance.

BusMgr

 

[GoDawgs]

I think this should work...in the recordsource of the report try this:

TheWeight: TheWeight: Int([FieldName]) & " Pounds, " & ([FieldName]-Int([FieldName]))*16 & " Ounces"

Then you can use that field in your report. There are other options for where to put this and how to display...let us know what you'd like. Hope that helps.

Kevin