Trim value to millions place

[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.

 

[Jerry Whittle]

Divide by 1000000.

 

[KARL DEWEY]

Int([YourField]/1000000)

 

[John W. Vinson]

On Wed, 25 Feb 2009 10:03:00 -0800, KARL DEWEY <karl

Int([YourField]/1000000)

Or (much more obscurely) use the integer divide operator

[YourField] \ 1000000