Rounding numbers to 2 DP

C

Craig Dovey

I am multiplying numbers in two fields to return a number to a third field.

I use the following formula

Field3 = Round( Field1 * Field2 , 2)

This works fine - however when the answer is exactly 0.5, 1.5, 2.5 etc.. it
will round up rather than round down.

Does anybody know the solution to this problem?

Thanks
 

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

Found a Bug or Error in Access 2002-2003 Round Function 3
Rounding up to 2 decimal places 2
Adding multiple fields in a single record in access 2k 1
Adding Expressions or Criteria or Lookup to a table 3
How do I stop Access from rounding numbers? 3
Stop Rounding in Forms 2
rounding up 1
Preventing rounding numbers to nearest dollar 2

Top