By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,164 Members | 1,001 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,164 IT Pros & Developers. It's quick & easy.

Round up numbers to the thousand

P: 2
I need to set a column in Access to round numbers up to the nearest thousand. If this can be done, is there an easy way to set this up? Thanks!
Oct 8 '06 #1
Share this Question
Share on Google+
4 Replies

Expert 100+
P: 1,418
Try using this in your column

YourColumn:Int([YourValue] * 1000 + 0.5) / 1000

Oct 8 '06 #2

P: 2
Hi PEB, Thank you. I was hoping I would know what to do with the answer. Where do I put that? Is it in a query or the table, or is it SQL or VB?

And how do I fill in the "YourColumn" and the "Your Value"?

YourColumn:Int([YourValue] * 1000 + 0.5) / 1000

I hope my questions are easily answerable!
Thanks again
Oct 9 '06 #3

Expert 100+
P: 1,418

You need to put it in your query, as a column!

Oct 9 '06 #4

P: 3
Its backwards. The formula should be:

Column_Name: Int( [Value_to_round] / 1000 + .5 ) * 1000
Aug 1 '07 #5

Post your reply

Sign in to post your reply or Sign up for a free account.