>This is obviously just a piece of the code but, when it hits this area I receive this error "data type mismatch". The column a.split_in is a character, but I need to use this in order to run my calculation.
>
>
>select iif(a.split_in="Y",a.price*a.catchweight,"")as T
>
Use the debugger to check the data type of each of the following:
a.split_in (should be "C")
a.price (should be "N")
a.chatchweight (should be "N")
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)