[AccessD] Report Summing Help

Thanks Jim:

I'm probably going to end up doing something like that; basically will
create a subreport with the YTD Totals. 

Larry Mrazek
LCM Research, Inc.
www.lcm-res.com
lmrazek at lcm-res.com
ph. 314-432-5886
fx. 314-432-3304

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Hale, Jim
Sent: Monday, January 09, 2006 3:37 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Report Summing Help

One way to do it would be to create a 2 field table where field 1 is a
number from 1 to 12 representing the month. Field two is the text name of
the month Jan, Feb, Mar etc. Join this table with your data table. In the
query grid select the prevyrdata and curryrdata fields and the new month
number field. Select groupby but change the month number field to a where
clause. in the criteria place >=3. The result should be a two field record
with the totals you want. HTH Jim Hale 

-----Original Message-----
From: Lawrence Mrazek [mailto:lmrazek at lcm-res.com]
Sent: Monday, January 09, 2006 3:17 PM
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] Report Summing Help


Hi:

I have a report comparing previous year data with current year data. Let's
assume that the report was run for period 4, which included everything
Jan-March data:

Month:	PrevYrData	CurrYrData
Jan		10		10
Feb		20		10
Mar		10		10
Apr		10		0
May		10		0
Jun		10		0
Jul		10		0
Aug		10		0
Sept		10		0
Oct		10		0
Nov		10		0
Dec		10		0

Totals YTD	40		30 (I need it to do this)
Totals	130		30	 

I'd like the report to be able to calculate the YTD comparison totals, that
is, if we ran the report for the first 4 months, it would automatically
create YTD totals for the previous year for the first 4 months (instead of
calculating for all 12 months). 

Any ideas on how to approach this? This is generated from data off a
mainframe, so I don't have a lot of control over the format and fields. 

Thanks in advance.

Larry Mrazek
LCM Research, Inc.
www.lcm-res.com
lmrazek at lcm-res.com
ph. 314-432-5886
fx. 314-432-3304



--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

***********************************************************************
The information transmitted is intended solely for the individual or entity
to which it is addressed and may contain confidential and/or privileged
material. Any review, retransmission, dissemination or other use of or
taking action in reliance upon this information by persons or entities other
than the intended recipient is prohibited.
If you have received this email in error please contact the sender and
delete the material from any computer. As a recipient of this email, you are
responsible for screening its contents and the contents of any attachments
for the presence of viruses. No liability is accepted for any damages caused
by any virus transmitted by this email.
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com