I am trying to truncate two different types of data (percents and money), percents to 4 decimal places and money to 2. I am creating a SQL Update statement, and calling formatnumber with the appropriate decimal specification for each field. However, when I look at the data in Access, the data was not truncated. Any suggestions on how to get this to work??? I need to actually truncate, and not round...for example...I want $15.877 to be saved to Access as $15.87. <BR><BR>Here's part of my SQL....<BR> strSQL = strSQL & " New_Hourly_Rate = " & FormatNumber(newrate,2) & ", "<BR><BR>(the rest of the sql statement is set up the same as this one line...<BR><BR>PLEASE HELP!!!! THANKS!