>I needed to change a field from numeric to currency my data type of a fields in my table to then I get 4 decimals like $5.0000 type of data.
>
>I have the default set to 2 in the options and have tried the set decimals to 2 didn't work.
>
> Thanks.
> Kelly
Use the ROUND(number,2) function.
Larry Miller
MCSD
LWMiller3@verizon.netAccumulate learning by study, understand what you learn by questioning. -- Mingjiao