>>Hi Sergio,
>>How many tables are you trying to use for this report?
>I'm using two tables.
>
>Each table represents an expense account, similar structure, both have to print on the same page.
>
>Thanks for your response.
Try:
SELECT *,1 AS TabNum ;
FROM table1 ;
UNION ALL ;
(SELECT *,2 AS TabNum ;
FROM table2) ;
UNION ALL ;
(SELECT *, 3 AS TabNum ;
FROM table3) ;
ORDER BY TabNum ;
INTO CURSOR alltable
Now do your report using "alltable" cursor and group as needed.