First, an apology for wasting your time.

The reason it was skipping 183 was that I was running the script a second time without clearing the field properly. The real reason why it was not working is that I asked the script to find 13 records when only 12 matched the criteria demanded. Stupid of me.

Thanks for your help.

Charlie

On Wed, Jan 15, 2014 at 12:39 PM, Richard S. Russell <[log in to unmask]> wrote:

On 2014 Jan 15, at 11:23, Charles Hartley <[log in to unmask]> wrote:

I turned off the "keep sorted by" but the script still skipped #183.

OK, worth a shot.

The next thing I notice is that you jumped from 183 to 199, which is an increment of 16, your group size. That suggests that you have somehow erroneously incremented the outer loop by 1.

Are you using FMP Advanced? If so, turn on the Script Debugger and Data Viewer and keep an eye on that outer-loop counter.