I'm familiar with the ability of Excel to pull out data from Sage using the ODBC driver while running MS Query. Typically I would look at debits and credits for each nominal code for each month. A new client has organsised their nominal structure to include departments. When I try to set up a Query to deal with this (I am not a database specialist) I receive an error message saying "the query wizard cannot continue because it could not join the tables in your query". Is it possible to link these tables manually, and if so then how?
The end goal is a tab in excel that shows the movements in each nominal code for each month for each department. It would be simplest to have a tab for each department.