Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2004
    Posts
    18

    Smile Unanswered: Simple fix I'm sure

    I have this DB to figure the markup based on wholesale cost,

    Private Sub Markup_Enter()
    Me.[Markup] = ([Cost] * 0.115)
    End Sub

    Problem is it's rounds up or down based, is there a simple wat to get this to give the correct number?

    Thanks in advance

  2. #2
    Join Date
    Feb 2004
    Location
    Swindon, UK
    Posts
    86
    After trying to re-create this, i found that it only rounds up, when the Markup format is set to currency. Leave the format as blank, and change the code as below if you require the pound sign.

    Private Sub Markup_Enter()
    Me.[Markup] = "" & ([Cost] * 0.115)
    End Sub

    that should then work out ok. for example. if Cost is 2.50, then markup is 0.2875, where as with the format set to currency, the result would equal 0.29.
    "Computers make it easier to do a lot of things, but most of the things they make it easier to do don't need to be done."

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •