1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Building an access database

Discussion in 'Business Applications' started by blessnhappy, Apr 23, 2012.

Thread Status:
Not open for further replies.
Advertisement
  1. blessnhappy

    blessnhappy Thread Starter

    Joined:
    Apr 23, 2012
    Messages:
    69
    No, I do not need to store the Discount information each person discount is suppose to be base on the amount of year of service multiply by two 2% (BSOSplit%) but there are different cases.
     
  2. blessnhappy

    blessnhappy Thread Starter

    Joined:
    Apr 23, 2012
    Messages:
    69
    I'm sorry:eek: I do need to store the discount information I was reading the post incorrectly. LOl (at my self)
     
  3. blessnhappy

    blessnhappy Thread Starter

    Joined:
    Apr 23, 2012
    Messages:
    69
    Discount is working also.
     
  4. OBP

    OBP Trusted Advisor

    Joined:
    Mar 8, 2005
    Messages:
    18,834
    Can you work out the retireeAmount now?
     
  5. blessnhappy

    blessnhappy Thread Starter

    Joined:
    Apr 23, 2012
    Messages:
    69
    No, still have issue with it.
     
  6. OBP

    OBP Trusted Advisor

    Joined:
    Mar 8, 2005
    Messages:
    18,834
    Try
    me.RetireeAmount =me.[Premium]-(me.[Premium]*me.[Discount])
    Although if you put it after the previous vba code you should be able to use
    me.RetireeAmount =me.[Premium]-me.[BSO Amount]
    because the [BSO Amount] should now be in place.
     
  7. blessnhappy

    blessnhappy Thread Starter

    Joined:
    Apr 23, 2012
    Messages:
    69
    I tired both and none did the trick.
     
  8. OBP

    OBP Trusted Advisor

    Joined:
    Mar 8, 2005
    Messages:
    18,834
    What is happening?
    Are you sure about the Field names?
    Have you removed the Calculation from the Control Source?
     
  9. blessnhappy

    blessnhappy Thread Starter

    Joined:
    Apr 23, 2012
    Messages:
    69
    The Field names is correct. I try removing the calculation in control source it did not work at all. I attached a zip file on all I have done please take a look, there is two dummy input.
     

    Attached Files:

  10. OBP

    OBP Trusted Advisor

    Joined:
    Mar 8, 2005
    Messages:
    18,834
    Your RetireeAmount Field is actually called "2012 RetireeAmount".
    I have added the adjusted VBA code to both Premium and Discount fields and it is now working.
     
  11. OBP

    OBP Trusted Advisor

    Joined:
    Mar 8, 2005
    Messages:
    18,834
    Here is the updated version.
     

    Attached Files:

  12. blessnhappy

    blessnhappy Thread Starter

    Joined:
    Apr 23, 2012
    Messages:
    69
    It did work.
    Would the same concept work for (BSO Retiree split %)? I keep changing the way I input the formula I'm still getting the funky result.

    And if I did the same thing I did with Departments field to the plan and premium field will it work also?
     
  13. blessnhappy

    blessnhappy Thread Starter

    Joined:
    Apr 23, 2012
    Messages:
    69
    After speaking to someone in my department I am thinking off omitting the RetireeSplit%, she will be giving me that part of information and that calculation will be done by her for now.
     
  14. OBP

    OBP Trusted Advisor

    Joined:
    Mar 8, 2005
    Messages:
    18,834
    The VBA code can be made to work for the RetireeSplit% if you want, it is up to you.
     
  15. blessnhappy

    blessnhappy Thread Starter

    Joined:
    Apr 23, 2012
    Messages:
    69
    Sorry for the late reply, I have been study for my biology finals.
    If I can make the RetireeSplit% work I will have a go at it.
     
As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/1050568