Cumulative total in query

[MikeWaring]

We have a query that extracts the SKU and qty of products that we sell daily. This query is used to create a csv file that we send to our supplier's EDI system to re-order those products. The query takes its data from a table that is overwritten every day; this table contains all of that day's sales.
What I need is to be able to get this query to break the daily re-order down into batches of say £130. When this point is reached, the query will stop and then run another one until the next £130 is reached, and so - on. At each stop, the query will need to delete the records that are in the query.
If necessary, I can build a Make-table query that will hold the whole day's order from which the query can delete the records mentioned above.
The query itself only contains 3 fileds, SKU, SumQty and Line Price (ie tot price of each SKU*Qty).

Is it possible to do such a thing? As mentioned in previous posts, I'm not very good at programming from theory, so if someone could do an example query, I'd be most grateful. I've attached a sampl db that contains the relevant stuff.
Thanks in advance for any help!
Mike

[William McKinley]

A few stupid questions:

1. Why are you deleting the data table daily?
2. How are you calculating your reorder points?

[MikeWaring]

Hi William, thanks for the post. The data table is an import from a csv file that is made by our website to provide us with details of all the daily sales that need shipping that day. We run this in the morning into our database which prints off all the customer invoices / labels etc for the warehouse. Once the database has done this, the data is redundant as it the sales are stored in our website back office. We produce upwards of 200 invoices a day so it would soon make the database a huge file.

Not sure what you refer to as our "Order points" - maybe you can advise in a little more detail?

The reason that we need to split the product re-order list is that if we put a large single daily order in to the supplier, it comes on a pallet with a transport company; unfortunately our warehouse is the very last drop on their route which means the order is nearly always too late for us to get the products out that same day. However, if we place the order in several smaller batches throughout the day, it is sent by UPS who deliver to us early morning, thus enabling us to get the products shipped. We have no say on the supplier's transport choices, but we have learnt to use it to our advantage.
Hope this helps to frame the issues and why we need this project sorted.
Kind rgds
Mike