[AccessD] Normalize Data by date

Example data
Well_Number		Production_Date		Water_Volume
CO2_Volume
1			1/1/2005			10
10
1			2/1/2005			20
15
1			3/1/2005			25
20
2			4/1/2005			50
35
2			5/1/2005			75
100
2			6/1/2005			44
87
3			10/1/2005			100
20
3			11/1/2005			200
40
4			2/1/2006			123
57
4			3/1/2006			44
23

To normalize the data what I need to do is sum the Water_Volumes and
CO2_Volumes for the first date for each well, second date etc. Thus for
dimensionless date 1 well 1 on 1/1/2005 is added to well 2 on 4/1/2005
is added to well 3 on 10/1/2005 and is added to well 4 on 2/1/2006. For
Water_Volume on first date 10+50+100+123. For CO2_Volume on first date
10+35+20+57. The again for the second date for sum wells etc. Hope this
makes sense. Thanks.

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin
- Beach Access Software
Sent: Thursday, March 02, 2006 10:17 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Normalize Data by date

Chester:

Sorry for the late reply.  What exactly do you mean by "normalize back 
to the first volume date"?  Can you give an example?

Regards,

Rocky Smolin
Beach Access Software
858-259-4334
www.e-z-mrp.com


Kaup, Chester wrote:
> I have a table with 4 columns of data. The fields are  Well_Number,
> Production_Date, Water_Volume and CO2_Volume. I need to normalize
these
> back to the first volume date separately for Water_Volume and
> CO2_Volume. ie sum the first volumes data together regardless of date
> and through the rest of the records. Hope I am making sense. I am at a
> loss of where to start. Thanks.
>
>  
>
> 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.
>
>  
>
>   

-- 
Rocky Smolin
Beach Access Software
858-259-4334
www.e-z-mrp.com

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