Rounding Up in a Query

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

Guest

I am making a query where I times a field from a table (Annual Salary)
by 1.5 to get a base. How do I get it to round up to the nearest 1,000.

Thanks!
 
Do you mean rounding to the nearest 1000 or round UP to the multiple of 1000
that greater than the result?

If it is the former case, try:

(CInt([YourField] * 1.5 / 1000)) * 1000


If it is the later case, try:

- (Int(-[YourField] * 1.5 / 1000)) * 1000
 
Van T Dinh,

I meant rounding up to the multiple of 1000 that is greater than the
result. Thank you for the formula. I really appreciate the help!

Van T. Dinh said:
Do you mean rounding to the nearest 1000 or round UP to the multiple of 1000
that greater than the result?

If it is the former case, try:

(CInt([YourField] * 1.5 / 1000)) * 1000


If it is the later case, try:

- (Int(-[YourField] * 1.5 / 1000)) * 1000

--
HTH
Van T. Dinh
MVP (Access)


Tandy said:
I am making a query where I times a field from a table (Annual Salary)
by 1.5 to get a base. How do I get it to round up to the nearest 1,000.

Thanks!
Click to expand...
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

in access, round up to nearest fraction(.5) 1
Why is my query asking for a paramater? 6
I need to always Round UP if greater than zero at all. HOW? 6
computation of calculated field in query based on conditions 3
Rounding up 4
rounding up to the nearest 1000 1
rounding to closest 15 minute increment 1
Round up or down to nearest 5, but not 10 2

Back
Top