Is there a way to count through a recordset and assign a value to the amount of records that you want? I would like to have a form that I enter a number, let us say 24 as an example (This number will change for each recordset). Then I would like to open an update query (or anything else) and assign a period value of ?Period 1? to the first 24 records (That is what I entered in the form). The next 24 records I would like to enter ?Period 2? and so on until I complete ?Period 8?.
Real world situation
There is a list of list of things to be accomplished which is represented by the recordset that is in the order it is to be done in. The individual is capable of doing 24 of them in an hour. I would like to see at which point each individual will be at, or should be at, at each period.
