how to round up down numbers to the nnearest 1000

G

Guest

how can I use the format field the propertirs section or else where to get
numbers to round up or doem to the nearest 1000 , in Access 2002
 
G

Guest

Hi Danny,

Formats only change the appearance of data, as displayed on your monitor or
printed in a report, unless the format function is used in an update query.
You can try using either the format or round function in an update query to
permanently change your data. Examples in the "Update To:" row of the QBE
grid would include the following. Note: I have not done exhaustive testing at
this point.

Round([FieldName]/1000,0)*1000
or
Format(([FieldName]/1000),"#.")*1000

You might want to also read a paper by Luke Chung:
When Access Math Doesn't Add Up
http://www.fmsinc.com/tpapers/math/index.html


Tom
____________________________________

:

how can I use the format field the propertirs section or else where to get
numbers to round up or doem to the nearest 1000 , in Access 2002
 

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

Rounding up! 2
Round number subject to it's value 1
Rounding Numbers 1
How do I round a number upwards in a query? 3
decimal display 10
Round to a Multiple 2
Access Round() Function Question 5
rounding up to the nearest 1000 1

Top