Results 1 to 3 of 3
  1. #1
    shankar.nst is offline Novice
    Windows XP Access 2003
    Join Date
    Sep 2011
    Posts
    1

    Pay calculation

    Hai all,



    Pls tell me how to write a code to get some calculation based form like;

    if a form contains three textboxes

    Pay: If we give any amount
    DA: a percent of amount should be added to the above
    HRA: a percent of the amount on the added amount of the above two and so on..,

    after entering amount in pay textbox, if we hits a command button. the remaining amounts should show.

    Pls provide me the solution.

  2. #2
    Dan is offline Novice
    Windows XP Access 2007
    Join Date
    Sep 2011
    Posts
    15
    txtResultBox.value = (txtPay.Value * ( 1 + DA % ) ) + ( ( txtPay.Value * ( 1 + DA % )) * ( 1 + ( txtPay.Value * ( 1 + HRA % )) )

  3. #3
    Dan is offline Novice
    Windows XP Access 2007
    Join Date
    Sep 2011
    Posts
    15
    deleted do mixed up post.
    Last edited by Dan; 09-30-2011 at 01:49 PM.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. BMI calculation
    By puush in forum Programming
    Replies: 9
    Last Post: 08-19-2014, 05:05 AM
  2. Calculation
    By sabrish72 in forum Reports
    Replies: 3
    Last Post: 06-06-2011, 12:41 AM
  3. value calculation
    By kyle in forum Access
    Replies: 3
    Last Post: 03-06-2011, 12:29 PM
  4. Need help with calculation please
    By Gabriel984 in forum Forms
    Replies: 6
    Last Post: 09-09-2010, 12:06 PM
  5. Calculation Help
    By ErnieS in forum Access
    Replies: 13
    Last Post: 07-08-2010, 08:35 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums