Darrell
Registered User.
- Local time
- Today, 08:04
- Joined
- Feb 1, 2001
- Messages
- 306
I am trying to do a supply/demand shortages report and as such have tried valiantly to do a running sum calculation in a query but that was waaaaaay too painful and so I have given up and left the query reasonably simple.
On the report that is based on this query, I have a calculated field that specifies the number of days between 'today' and when demand outstrips supply (ie my running total of stock/supply/demand goes negative) inside of the planned delivery time for a given material.
If I run this report as is, it works fine but I now need it to only show me the materials where this is actually the case. 99% of the materials don't go negative inside of the planned delivery time and so I don't care about them.
Any help appreciated
dh
On the report that is based on this query, I have a calculated field that specifies the number of days between 'today' and when demand outstrips supply (ie my running total of stock/supply/demand goes negative) inside of the planned delivery time for a given material.
If I run this report as is, it works fine but I now need it to only show me the materials where this is actually the case. 99% of the materials don't go negative inside of the planned delivery time and so I don't care about them.
Any help appreciated
dh