I'll give it a try thanks Fred.!!




>>>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.