I have created an attendance report program which imports student names into the attendance file on a daily basis, and enters today's date into the date field. From this daily updated list, teachers check the student present or absent.

My formula to enter today' date into 100 plus

date fields is:

Go to Layout (attendance)

Loop

Go to Field (date)

if(date=0)

Insert current date (date)

Go to ecord request/Page

(next)

Exit Loop if (Date=1)

End if

End Loop

___________

This formula enters all the dates into the empty date fields, but does not exit by itself. I have to press escape to stop the formula from working. What am I missing beside a few brain cells??

Bob Sherman

[This message has been edited by rmsherman (edited October 07, 2000).]

In most loops were you are processing down through a set of records, one of the exit steps should be: Go to Record/Request/Page (next, exit after last). This will cause the loop to go through all the reocords and exit when there is not a next record to go to. -bd

[This message has been edited by LiveOak (edited October 07, 2000).]