Hi Michelle,

The code following works beautifully in the command window:

yAmount = $14.45
nNetWt = 300
? yAmount / nNetWt ( result is 0.0482 )

The dollar sign makes no difference.

You might want to check the values with VARTYPE() to be certain that the values are the types you want. Also, look at Tools/Options/Regional and see if the currency settings there might be messed up.

HTH,
Evan

>I have an SQL SELECT that produces a Y and a N(14,0). I want to divide the Y by the N, but it keeps telling me "currency value is out of range". I even tried ROUND(amount/netwgt,2) but it doesn't like that, either.
>
>Any ideas?
>
>Thanks,
>
>Michelle