Welcome to the PlusCommunity forums! PlusCommunity is a gathering place for companies running Simply Accounting, ACCPAC Plus, Sage Accpac ERP(ACCPAC Advantage/ACCPAC for Windows), and Adagio Accounting. New visitors, please click here!
I am using Microsoft Query to pull data from GLPOST and in the result of the query, I would like to have all the months including those that do not have any data so when I summarize the data in a pivot table, it looks clean.
I think I would need to create an outer join to a months table but is there a better way to accomplish this?