Hi,

How do i automate the adding of units behind the numerical datas? Only when user enter the numerical datas, then upon print report, the report will show the numerical datas with unit, when there is no numerical datas, the units wont appear? :confused:

In the underlying query, you could concatenate the fld value (data) with the unit text ('each', 'roll, etc)

Would this work?
Ken