Results 1 to 3 of 3
  1. #1
    Maggie is offline Novice
    Windows XP Access 2007
    Join Date
    Oct 2011
    Posts
    1

    Calculation

    Help!!!



    Can anyone tell me how to add a calculation that will minus a balance total when using a witdrawal transaction or increase the balance using a deposit transaction?

    Or tell me what type of formula to use.

    Many Thanks

  2. #2
    hertfordkc is offline 18 year novice
    Windows XP Access 2007
    Join Date
    Mar 2011
    Posts
    481
    Your questions suggests that you are looking at your calculation as an Excel problem.
    In Access, I have a transactions table consisting of account number, transaction date, transaction type and amount. Every time the transaction table is altered, a query gets the new total. No formula involved.
    Repost is you need clarification. Or mark it as solved if you are able to do it.

  3. #3
    alansidman's Avatar
    alansidman is offline VIP
    Windows 7 32bit Access 2007
    Join Date
    Apr 2010
    Location
    Steamboat Springs
    Posts
    2,529
    Here is a sample template for a check book that does what you are referring to. Look it over. You will need to make sure that both files are located in the same directory for it to work.

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. 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. 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