David wrote:

> Hi Lester:
> thanks in advance for the time I really apreaciated
> I'm sorry to bother you but I'm trying to put a page break to this report
> but I have 4 different queries and I need to make only one.
> And the problem I cannot get to make this work with the queries below.
> that why I was trying to make only one query

This looks like an ideal case for pulling the results into an array in
php, and then printing that array a page at a time ...
Then you can add totals as you go?

--
Lester Caine - G8HFL
-----------------------------
Contact - http://lsces.co.uk/wiki/?page=contact
L.S.Caine Electronic Services - http://lsces.co.uk
EnquirySolve - http://enquirysolve.com/
Model Engineers Digital Workshop - http://medw.co.uk//
Firebird - http://www.firebirdsql.org/index.php