Hi Everyone:

Haven't been back here for a while for help as I've been pretty good at getting things to work on my own (thanks to a lot of previous help from people here!).

I can't, however, get this to work.

I use a function which runs a number of different select statements into their own individual cursor. the function creates, at present, 5 different cursors. This select function is called from a form in which a user selects two dates, and those dates are used in the function.

After the select function is run, a report is previewed based on the data in the cursor. Unfortunately, the only data that is available to the report writer is the most recent cursor, and not the previous cursors from the select statements.

Is there anyway that I can make all the cursors and their data available to the report at the same time? If I refer to the cursor name in the field of the report, the report only repeats the first value from the cursor over a number of pages, and doesn't list the other returned values from the select statement.

Hope this makes sense. It's late at night here and I've gone buggy trying to solve this and am probably not thinking straight :-)

Thanks

Paul