rounddown in access queries

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

Guest

Is it possible to round DOWN in access? I'm trying to transfer a scorecard
into access from excel, and i need this formula in it...Help?
 
Int() rounds a number down.

Fix() rounds positive values down, and negatives values up (i.e. rounding
towards zero.)
 
ok, i thought it worked, but when i compared it to my excel results,it was
different....
 
Ignore the previous post please! silly blond me forgot to change one of the
"round" to "int"

Thanks for your help!!
 
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

ROUNDDOWN 3
Help with Date Ranges 4
Round Down an Expression 3
Using ROUNDDOWN - Help please 3
Crosstab Query error message 1
round up and round down 8
How do you round a number DOWN (for age)? 2
returning blank cell in an if statement 2

Back
Top