Omit Loop

[wowmom]

I have a FM Pro 4 script that loops to tests the value of a field and omit the record if true. The problem is when there are two or more consecutive records that meet the test criteria. In this case, only every other record is omitted because the record is omitted and when the script reaches the goto next record step, it is going-to from the record AFTER the omitted record, not from after the record that was omitted.

So far, I've "solved" the problem by sorting by the test field and creating a loop that counts the desired records. I then loop again until I reach the desired field, and perform a multiple omit. But this involves user interaction to enter the value of the counter in the omit multiple dialog box.

What......?

------------------

Sad, sad day for America.

[Chuck]

Try placing the Go to Record [ Next ] within the same If statement that checks to see if the record needs to be omitted.

Loop

[wowmom]

Thank you for your prompt reply.

I've tried your solution, but it sends the script into an infinite loop.

[This message has been edited by wowmom (edited December 14, 2000).]

[Kurt Knippel]

quote:

---

Originally posted by Chuck:

Try placing the Go to Record [ Next ] within the same If statement that checks to see if the record needs to be omitted.

---

Try this instead, basically you want to either Omit the record or move onto the next record.

Loop

[wowmom]

This works perfectly. Thank you.

I can't wait to be good at this.

------------------

Sad, sad day for America.