Hi Evan:

How silly of me! Of course, CURSOR. Earlier today, I had been considering ARRAY. My fingers got confused!
If I can beat this into the ground...

The user selects the month and year for the report. The month and year are memory variables set up as m.month and m.year. I want the table to find all records that fall into that data range.

SELECT * FROM table1 WHERE CMONTH(table1.endingper)=m.month AND YEAR(table1.endingper)=m.year INTO CURSOR vreport

Working with dates has always been a tricky issue for me. I'm forever looking for a better way to manage with them.
Thanks for your help!

Kim