Hmmm...seems to me the bottom line is going to be that you need to combine them into a single cursor before running the report. Though not having all the details I couldn't say for sure. Could you make the story a little longer, by telling us what tables these fields are in? Perhaps posting one, or both of your SQL statements would shed more light.

>To make a long story short. We have a table that requires records to be subtotaled and printed twice and in different order on the report using two different sorting criteria to make two different columns. Something like this:
>
>

>A/C#     Description                         Debit             Credit
>----     ------------------------------   ----------         ----------
>560      Expense  - Furniture & Fixtures      26.20
>562      Expense  - Buildings              1,941.36
>564      Expense  - Autos                    117.14
>
>160      Acc/Depr - Furniture & Fixtures                         26.20
>162      Acc/Depr - Buildings                                 1,941.36
>164      Acc/Depr - Autos                                       117.14
>
>                                           ---------         -----------
>                                            2,084.70          2,084.70
>

>We are hoping that we could produce the report using two separate cursors. What do you think?
>
>Thanks for the response,
>
>Tom