I have 42 students and everyday a record is created for each in an attendance table. Each record collects the student ID, day, month, year and attendance status. How can I create a loop that will search for the "begin date" to the "end date" of the month (X) for each student?

I appreciate any ideas

Thanks.

short answer: write a looping script

What do you want to do with each found set? Pause the script and look at the data, print, something else?

...or, I just realized you may be wanting all attendance records for all students in a given month? For that, you would just perform a find on the month and year fields.