Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    May 2004
    Cambridge, Ontario, Canada
    Thanked 0 Times in 0 Posts

    Query Calculations (Access 2002)

    Hello Everyone.
    I'm trying to create some what of a circular formula to calculate stock for the company I work for using a query. I need to be able to take the quantity of material I have in stock and subtract the quantity required to build our product. The problem is, we have multiple products that use the same material. When I pull stock for the first product it calculates the stock correctly. When I try to pull stock it pulls the same stock the second time that it did the first. I need it to pull from the remaining stock the second time.

    Does anyone have any suggestions?
    Thank you in advance

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Thanked 31 Times in 31 Posts

    Re: Query Calculations (Access 2002)

    You will have to use an update query that actually changes the stock value by subtracting the quantity of material needed from the current stock. That way, next time you run the query, it will start with the new stock value.

Posting Permissions

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