Plus Community - for users of ACCPAC & Adagio accounting software

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!

Page 1 of 1 1
Topic Options
#53168 - 08/03/17 05:28 PM Query - How to extract all the fiscal periods
jnsimex
Member


Registered: 11/27/05
Posts: 366
Loc: Canada
Hi Everyone,

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?

Thanks.

Top
#53169 - 08/03/17 05:38 PM Re: Query - How to extract all the fiscal periods [Re: jnsimex]
Jay Converse Administrator
Member


Registered: 07/31/00
Posts: 7536
Loc: Location, Location
Use 12 formulas, one for each month
_________________________
Jay Converse
Sage 300 Whisperer

Top
#53170 - 08/03/17 06:00 PM Re: Query - How to extract all the fiscal periods [Re: Jay Converse]
jnsimex
Member


Registered: 11/27/05
Posts: 366
Loc: Canada
Do i create the formula fields in the pivot table?

Edited by jnsimex (08/03/17 06:07 PM)

Top
Page 1 of 1 1


Moderator:  Jay Converse 
Hop to: