Hi Ron,

Thanks for responding.

I have already got a solution that works using Access tables that are
'joined' but l felt that it is to slow & inefficient.

I was hoping to develop a solution in VBA that uses SQL to directly
query across multiple tables in the financials database (Sage). I
would then apply an SQL statement to the results retrieved to Excel
(ie the crosstab query)

I am getting there SLOWLY and the example workbook will help me build
the SQL code and points me in the right direction re manipulating the
data retrieved into the Excel workbook.

I hope all this work actually results in quicker code!

Regards

Michael Beckinsale