Rounding thousands in Access

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I know in Excel you can change the format in a cell to round to thousands
using the 0, format. Can you do the same in an Access query, if so, please
advise.

Thanks heaps,
Chris
 
I know in Excel you can change the format in a cell to round to thousands
using the 0, format. Can you do the same in an Access query, if so, please
advise.
Click to expand...

RoundNum: 1000 * ([field] \ 1000)

John W. Vinson[MVP]
 
That's great thank you, however is there a way of removing the ,000 e.g I
have 405,954 and would like to get 406. Thanks heaps, Chris O

John Vinson said:
I know in Excel you can change the format in a cell to round to thousands
using the 0, format. Can you do the same in an Access query, if so, please
advise.
Click to expand...

RoundNum: 1000 * ([field] \ 1000)

John W. Vinson[MVP]
Click to expand...
 
Thank you, I actually answered my own question being 1*[field]/1000. Thanks
heaps

Chris O said:
That's great thank you, however is there a way of removing the ,000 e.g I
have 405,954 and would like to get 406. Thanks heaps, Chris O

John Vinson said:
I know in Excel you can change the format in a cell to round to thousands
using the 0, format. Can you do the same in an Access query, if so, please
advise.
Click to expand...

RoundNum: 1000 * ([field] \ 1000)

John W. Vinson[MVP]
Click to expand...
Click to expand...
 
Thank you, I actually answered my own question being 1*[field]/1000. Thanks
heaps
Click to expand...

Actually a bit shorter: you can use the \ Integer Divide operator.
/1000 will convert 329,416 to 329.416 (and you'll need a format
expression to conceal the fraction; \1000 will give an integer 329 as
a result.

John W. Vinson[MVP]
 
Back
Top