>If a field has a decimal point, I want to change its default format to a currency format. What is the best way to determine if a numeric field has a decimal point?

Try AFIELDS() on the table. Once you've located the field, the number of decimals places is in the fourth column.

hth,