That did work! Running the query in studio manager returned exactly what it was supposed to. Unfortunately, I now have an issue with Crystal Reports passing that query...

I do understand what you are doing there. I did not realize that was a possibility though. I am going to run this through the mill and I...

GLAccum table:

CREATE TABLE [dbo].[GLAccum](

[LOCATION] [varchar](2) NOT NULL,

[GLACCUMKEY] [int] IDENTITY(1,1) NOT NULL,

[ACCTPERIOD] [decimal](7, 0) NULL,

[GLCHARTKEY] [int] NULL,

[BASE] [varchar](15) NULL,

[DIVISION] [varchar](2) NULL,

[DEPTNO] [varchar](5) NULL,

[BEGBAL] [decimal](13, 2) NULL,

[ENDBAL] [decimal](13, 2) NULL,

[ACTIVITYAMT] [decimal](13, 2)...