Thanks for the help... I was messed up on my quotes on the SQL statement.

Tommy

>Hi Tommy,
>
>Look at the NTOM() and MTON() functions. They'll convert numeric to currency (NTOM = Numeric TO Money) and currency to numeric (MTON = Money TO Numeric).
>
>Why they didn't use NTOY() and YTON() I'll never understand (sigh)...
>
>HTH.
>