Results 1 to 4 of 4
  1. #1
    2skannan is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Jan 2013
    Posts
    2

    Exclamation Calling previous value to add with new value

    Hello all,
    This question may even not have the standard of being put in the programming category, but still bare me.. I'm very new to access.
    The problem with me is as follows. I'm making a database for sale of mineral water in my area. In doing so I have first created a data base of my customers with a "customer enrollment form" and a DB to store the data. Then I created a form to enter the sales details associated with my customers. In that I have the following fields linking to a data base for it -Date of sale, Customer ID, No of bottles & Amount paid. Now suppose one of my customer did not pay me all the amount to the number of bottles he purchased from me, and kept some balance pending. In such a situation I created a Query to calculate the balance amount. Now, the next time when I reach the same customer, I face the same problem, and he again keeps some money pending. In such a situation how can I look at his previous balance and calculate the new outstanding balance..


    As I said, I'm very new to all these and so please guide me out of this...
    Regards
    Kannan

  2. #2
    orange's Avatar
    orange is offline Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    Have you built your tables and relationships? Have you Normalized your database?
    You may get a good overview from this http://forums.aspfree.com/attachment...2&d=1201055452

  3. #3
    2skannan is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Jan 2013
    Posts
    2
    Quote Originally Posted by orange View Post
    Have you built your tables and relationships? Have you Normalized your database?
    You may get a good overview from this http://forums.aspfree.com/attachment...2&d=1201055452

    yes
    i have created relationships.the DB feels to be normalized.. What next?

  4. #4
    alcapps is offline Competent Performer
    Windows XP Access 2003
    Join Date
    Jan 2012
    Posts
    292
    usually in a transactional situation. you would have an invoice for sales. In the database you might have items sold and which customer. you will need a seperate entry of
    customer ID
    Payment date
    payment method ->
    1. cash
    2. credit card
    3. check
    PaymentNumber 'credit card number or check number
    PaymentAmount
    PaymentComment

    something like this. So you have a purchase and a payment record.

    Now you can calculate balances.
    add up all the cost or purchases and subtract all the payments = balance due.

    I hope this helps..

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

Similar Threads

  1. Calling a Function From A Form.
    By ksmith in forum Access
    Replies: 2
    Last Post: 06-07-2012, 02:23 PM
  2. calling mdb from command line.
    By gsd in forum Access
    Replies: 4
    Last Post: 05-04-2012, 08:17 PM
  3. calling function
    By ManvinderKaur in forum Programming
    Replies: 3
    Last Post: 07-22-2010, 10:53 PM
  4. Replies: 4
    Last Post: 03-31-2010, 03:41 PM
  5. Calling Query from different Access DB
    By Jerry8989 in forum Queries
    Replies: 4
    Last Post: 10-02-2009, 08:48 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