Translate salaries to 3 digits

  • Thread starter Thread starter Net via AccessMonster.com
  • Start date Start date
N

Net via AccessMonster.com

I have salaries in a field for example 45,600 this field is in a query, and
translating to a report in the report I need for this field to show as 45.6

Does someone know of a formula that I can use? Thank you!

Net
 
Rick B said:
=Salary/1000
Click to expand...

And use a Format to limit the number of decimal places shown, e.g.,

#,##0.0

If there some salaries are large, and you want comma thousands-digit
separators. #0.0 will do the trick if you don't want thousands-digit
separators. <GRIN>

Larry Linson
Microsoft Access MVP
 
Back
Top