>yes, create a cursor to be filled with a select statement later. You see, I'm having trouble figuring out how to reference a field in that cursor from a field in a report.
Stacy,
You can't. The SELECT will always overwrite the cursor you create. If you need specific field names in the cursor from the select use the AS option in the fields list;
SELECT Field1 AS MyFld1, Field2 AS MYFld2, ... INTO CURSOR MyResult
In the above the field names in the cursor can be referred to with either MyFld1, MyFld2 ... or MyResult.MyFld1, MyResult.MyFld2 ...