This blog is for Accountants who would like to empower themselves by being able to create applications for the company/companies they work for without full reliance on IT professionals. Accountants should know the type of data their company should collect and use the data to analyse and add value to the company's bottom line. They should be able create data collection applications that can be used across their organisation.
Sunday, January 15, 2017
Rounding function
When you do calculations, you may wish to round your numbers.
You used to have to use the RoundCC function. It gets easier now!
https://www.techonthenet.com/access/functions/numeric/round.php - For detailed information
In your Calculated field, you may wish to do this: Round([Item_cost]/3,0) which means, you do not have any decimal places, everything is rounded to the nearest dollar.
Labels:
access 2016,
Rounding
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment