I'm not sure how to approach this one. I am working on a query (soon to be a report) that is will be give me a percent usage of a part we use every day listed by project. The problem is that I need to be able to limit this query to provide me the percent usage over a given number of parts starting from the current day going back in history.
(For example, this report needs to provide me the usage by project for the part "PRN-2" over the last 30,000 parts used so that I can properly assign billing for this part.) How can I limit a query to show me the records for a given maximum running sum? Is this the right way to approach this?