[AccessD] Summerize data for report

Kaup, Chester Chester_Kaup at kindermorgan.com
Tue Nov 15 14:37:19 CST 2011


Of course right after my posting it occurred to me how to do this in the report. Use this as the control source modifying as necessary for various text boxes.

=DSum("[Well_Count]","tbl Monthly Well Count with EA","[Well Status] ='Active Injector CO2' ")

-----Original Message-----
From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Dan Waters
Sent: Tuesday, November 15, 2011 1:50 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Summerize data for report

Hi Chester,

If, on this report, you only want to display the count of wells, the I would
probably write a query to use as the recordsouce of the report.  Like this:

SELECT tblWells.EngArea, Sum(tblWells.WellCount) AS [Well Count]
FROM tblWells
GROUP BY tblWells.EngArea;

If you also need to display individual data on the report, then use the
grouping and sum features of the report.

Good Luck!
Dan

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Kaup, Chester
Sent: Tuesday, November 15, 2011 1:34 PM
To: Access Developers discussion and problem solving
Subject: [AccessD] Summerize data for report

I have the following data in a table. I have been able to make reports based
on each of the eng area's in the table. I now need to make a report with a
total well count for each category (well status) in the table. I have not
yet figured how to get a sum for each category in a report or do I need to
do a query and base the report on that? Thanks

tbl Monthly Well Count with EA

Well Status 		Well_Count 	Eng Area
Active Injector CO2	1		1 
Active Injector CO2	3		2
Active Injector CO2	0		3
Active Injector WAG	100		1
Active Injector WAG	122		2
Active Injector WAG	58		3
Active Injector Water	33		1
Active Injector Water	93		2
Active Injector Water	85		3
Inactive Injector		36		1
Inactive Injector		25		2
Inactive Injector		31		3


Chester Kaup
Engineering Technician
Kinder Morgan CO2 Company, LLP
Office (432) 688-3797
FAX (432) 688-3799

 
No trees were killed in the sending of this message. However a large number
of electrons were terribly inconvenienced.


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


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





More information about the AccessD mailing list