Running Sum of Sales Quantities

[cwhite23]

OK, I'm at my wits' end on this one! I need to be able to take a query of all of our open orders, and have a field that shows a running total on a line-by-line basis of our stock levels. For Example:

Item # Qty OH On Order Balance
123 100 10 90
123 100 25 65
123 100 75 -10
etc.

I have been going around in circles with the DSum function and have gotten nowhere. Anyone have any ideas? My goal here is to show all of the orders that we can ship based on current stock levels. Any help would be appreciated.

 

[CautionMP]

cwhite23,
Try searching for:
[tab][tt]running total[/tt]
[tab][tt]running sum[/tt]
In:
[tab]Microsoft: Access Queries and JET SQL Forum

Hope this helps,
CMP


[small]For the best results do what I'm thinking, not what I'm saying.[/small]
(GMT-07:00) Mountain Time (US & Canada)

 

[cwhite23]

I've been through every thread I can find on both of those subjects without success. I keep getting a grand total for all records. Any ideas?

 

[Hafa1961]

Try this:

http://www.rogersaccesslibrary.com/Otherdownload.asp?SampleName='RunningCountSum_2K.mdb'

 

[cwhite23]

I downloaded the software and took a look at how they were doing it. That's exactly what I need with one exception. Our Item numbers are alphanumeric. Can DSum work with this or does the Item number have to be numeric? If, now, what are our options?

 

[PHV]

Any chance you could post what you have tried so far ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[cwhite23]

Actually, I finally got it to work. In all of my reading on the DSum command, I had not run across the fact that you can't do a DSum on an alphanumeric (text) field. What I ended up having to do was to assign a unique ID number to each of our item numbers (which are alphanumeric), and used DSum on the ID field. I still appreciate all of the help!