Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2009

    Unanswered: Calculated field allowing manual entry/override?

    I am using Access 2003, and have created a simple Sales form. On the form, you can select a product, and its price, and at the bottom, a calculated field will tell you the amount of tax, and a separate field will tell you the total price.
    When we sell wholesale, the customer pays no tax. I need a simple way to either
    a) erase the calculated tax and manually replace with "0.00"
    b) have the tax field know that when an order type of "wholesale" is selected, it means no tax.
    Right now, I cannot simply erase the populated calculation in the tax field at all.
    Any suggestions?
    I would love it!

  2. #2
    Join Date
    May 2005
    Welcome to the forums

    I believe we need more information than that to try and help you. What is the table(s) structure(s) look like that is driving this form? How are the values stored? Are they stored or calculated dynamically in queries and such? What does the form look like that this data is being entered? What controls are there, what type are there, what is populating them, and what are they intended to control? Etc.
    Quote Originally Posted by Teddy's FAQ
    In short, give us half a chance at actually being able to answer your question. Make it as easy as possible, and you're FAR more likely to get a response.
    Me.Geek = True

  3. #3
    Join Date
    Nov 2007
    Adelaide, South Australia
    Have the tax field know that when an order type of "wholesale" is selected, it means no tax.

    Modify the expression that calculates the text to incorporate the appropriate IF condition.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!

    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

Posting Permissions

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