Results 1 to 2 of 2
  1. #1
    buienxg is offline Novice
    Windows XP Access 2000
    Join Date
    Nov 2011
    Posts
    15

    Calculation

    Help!

    I have a table in access for pocket money


    I am trying to create a calculation in access that will minus the balance with a withdrawal and increase the balance with a deposit. Can any one tell me how to do this or tell me what kind of formula I should be using?



    Many thanks

  2. #2
    AdventureBob is offline Novice
    Windows Vista Access 2007
    Join Date
    Nov 2011
    Location
    kabul
    Posts
    13
    Im not sure of the structure of your table but...
    Make your entries in AmountFld either -$.$$ OR +$.$$
    then write a summation qry and it will do the math.

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 value not less than 1
    By vbpeterson in forum Queries
    Replies: 10
    Last Post: 08-17-2011, 06:41 AM
  3. How to do calculation???
    By latestgood in forum Forms
    Replies: 0
    Last Post: 05-18-2011, 11:11 AM
  4. value calculation
    By kyle in forum Access
    Replies: 3
    Last Post: 03-06-2011, 12:29 PM
  5. Need help with calculation please
    By Gabriel984 in forum Forms
    Replies: 6
    Last Post: 09-09-2010, 12:06 PM

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