Trim value to millions place

  • Thread starter Thread starter tighe
  • Start date Start date
T

tighe

I am trying to remove the last six of a number value to just keep the
miilions or more. so 10000000 becomes 10, and 2000000 becomes 2.

I Appreciate all help past and present.
 
On Wed, 25 Feb 2009 10:03:00 -0800, KARL DEWEY <karl
Int([YourField]/1000000)
Click to expand...

Or (much more obscurely) use the integer divide operator

[YourField] \ 1000000
 
Back
Top