>>Hi All, >> >>What is the quickest way to test if a numeric table field has a decimal portion? >
>int(field) <> field
That tells me if the specific number in the field has a decimal portion. I need to know if the field definition itself has been set to have a decimal portion. For field type double TYPE() and VARTYPE() both return "N".
In the End, we will remember not the words of our enemies, but the silence of our friends - Martin Luther King, Jr.