Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
why are my prices showing 4 zeros after the decimal point
- Thread starter dunskii
- Start date
#If you are using SQL server
open your table in design view, >select the field that is showing the 4 decimals> look down to where it says scale if there is a 4 change it to 2. Now your fields with prices will only show 2 decimals after the ".".
as for the records that have already been populated you may consider running a update query that finds all records with .0000 in the price and update it with .00.
hope this helped.
open your table in design view, >select the field that is showing the 4 decimals> look down to where it says scale if there is a 4 change it to 2. Now your fields with prices will only show 2 decimals after the ".".
as for the records that have already been populated you may consider running a update query that finds all records with .0000 in the price and update it with .00.
hope this helped.
- Status
Similar threads
- Locked
- Question
- Locked
- Question