Results 1 to 4 of 4
  1. #1
    New Lounger
    Join Date
    Sep 2001
    Posts
    23
    Thanks
    0
    Thanked 0 Times in 0 Posts

    #'s in one table affecting #'s in another table (Access 2000 (SR-1))

    I am attempting to affect numbers in one table by subtracting / adding numbers in another one.
    I am working on an inventory database and need to cause the quantity on hand to be reduced by the # of items sold and adding #'s of received stock. There is one table for on hand & one for calculations.
    Any help would be appreciated.
    Thanks in advance,
    Michael

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: #'s in one table affecting #'s in another table (Access 2000 (SR-1))

    You don't normally store values that can be calculated when you need them. However, if you are storing a calculated value, the simplest way is to use an update query.
    Charlotte

  3. #3
    New Lounger
    Join Date
    Sep 2001
    Posts
    23
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: #'s in one table affecting #'s in another table (Access 2000 (SR-1))

    Charlotte,
    Thanks for responding! I am working on this project for someone else, so I'm not sure for the reasoning of storing these values. But then again I am not sure how to make an update query do this task either. I will continue to work on this and once again thanks for the input.
    Michael

  4. #4
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: #'s in one table affecting #'s in another table (Access 2000 (SR-1))

    As Charlotte said, storing calculated values is a VERY bad idea. The reason is that if someone comes changes a value in worksheet mode to fix a problem, the stored calculated value will not be changed and is no longer correct. You should try to convice the person you are doing this for not to do it.
    Legare Coleman

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •