Yep, and that one does work in all the cases I mentioned. However, I know AFIELDS will always work because it is not dependent on deriving the decimals based on some value in a field. Alan's solution fails if the value is NULL.
>IIRC, it was suggested to use PADL(FIELDNAME,20) instead of TRANSFORM() in one of previous discussion.
>
>>That was quite dense, and I would split up the RETURN line for readability. < g > Plus your results can be defeated by the actual value in the field. In the Invoices table in the NW DBC, I get no decimals using TRANSFORM() on the discount field regardless of the overall value of the field unless at least one of the decimal places has at least 1 non-zero value.
>>
Mark McCasland
Midlothian, TX USA