title: MS Access: Truncate Calculate Fields
body: <p>I am doing a migration of calculated data from Excel to Access and realized that Access does not have the Truncate function. I need the Truncate function to drop numbers to 2 decimal places, for e.g. 10.32790 to 10.32.  </p>
  
  <p>I created the module as specified here: <a href="http://www.anysitesupport.com/access-truncate-function/" rel="nofollow noreferrer">http://www.anysitesupport.com/access-truncate-function/</a>  </p>
  
  <p>However, I tried using the Trunc() function in the Calculated Field in my table (via expression builder) and was told that I could not do that to a calculated field. What is the proper way to make us of the newly created module?</p>