Re: New comer to reports

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Shelian,

I am beginning to get the picture. The answer to your question is relatively complex, and I can't answer fully right now. Unless somebody else chips in, I will get back to you later. In the meantime, yes, scream if you like - I know it often helps me. :-)

--
Steve Schapel, Microsoft Access MVP

shelian1 wrote:
OK this is what I mean (I hope I can explain it better). In my products table I have a field called "Op Bal". The "Inventory Transaction" table is where I enter all the daily "Ins & Outs". I want the query &/or the report to pull the "Op Bal" from the products table & then add or subtract what I enter from that "Op Bal". I created the "Subtotal" field for the "Ins" the "Total" field for the "Outs" & the "Grand Total" for the balance after it figures if units were brought in or sent out. So in other words, the query has "Op Bal" (from "Products" table), "Units In", "Units Out", "Pcs per Unit", "Subtotal", "Total" & "Grand Total". The "Grand Total". Each line may be different so I made it to do it this way & it would figure it either adding or subtracting & still come up with the balance. Anyway, then I NEED it to copy the "Grand Total" to the "Op Bal" for the next product with the same Product ID number. Let's say for Product ID 23456 the op bal is 12000 we bring in 2 units of 250 pcs. Well then that gets added onto 12000 which would make it 12500. Then the next entry is a different product ID. Two entries later we send out 3 units of 250 pcs. Now it would take that away from the 12500 which of course would be 11,750 left. So this figure should go in the next entry for product ID 23456 when ever it may be, either the next line or 2 days later. Please tell me you understand now. I am about to quit trying to figure it out, I just want to SCREAM!!! 
.

Relevant Pages