Thank you for your suggestion. I have tried every combination of join types and enforcements a while ago but still could not crack it. I have joined the tables using Nominal code and also Department code still, without success. I have also tried having the tables joined by Nominal and...
I am trying to produce a budget report for each department which details the nominal code and the respective totals for actual and budget using department as a header. The report I have produced is missing actuals where a budget does not exist for that nominal code in the other table...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.