Hi, I have never used Microsoft Query before, but I have managed to run
a simple query using SAGE as my external data source. I have easily
manged to return a few columns of data chosen from the Nominal table.
However, I want to be able to see my nominal ledger by departments (see
below)

Account Name Total Aug 05 Dept 1 Dept 2
4000 Service Sales 18,831.53 9415.765 9415.765
4001 Introducers Fees 0
4002 Do not use 0

However, Microsoft Query tells me that as I am trying to choose data
from two different tables and I must manually link them. This is where
I struggle. I can find the place where I am supposed to execute the
links, and I have sucessfully created a link, albeit that Microsoft
query tells me that I am trying to join columns that are of different
types. This is where I fall down. If the columns are of different
types does that mean I will not be able to create a report in excel
showing nominal balances against department.. ?? There must be a way
as there is a standard excel integrated reporting report set up that
pulls out dr and cr by dept, but I want my report formatted differently
than this standard report, hence my query. Any help would be much
appreciated