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

    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, is there a simple wat to get this to give the correct number?

    Thanks in advance

  2. #2
    Join Date
    Mar 2003
    The Bottom of The Barrel
    Provided Answers: 1
    what datatype is me.markup, and what datatype is cost? Money/Currency only has 2 significant digits by default...

    What sort of results are you getting vs. what you'd like to get?
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

Posting Permissions

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