Summing Fields by Given Period

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Tan SH (anonymous_at_discussions.microsoft.com)
Date: 06/30/04 

Date: Tue, 29 Jun 2004 20:25:49 -0700

Hi,

I have the following table (DATA_DAY)with the folloing
fields:

ObjectID, Date, Value1, Value2, Value3

I need a query that can sum up the values of Value1,
Value2, Value3 for a particular Object_ID, for a given
period. In addition, I need to insert the results of this
query into a second table, DATA_DAY_ACC. This table has
the following fields:

ObjectID, Start_Date, End_Date, Sum_Value1, Sum_Value2,
SumValue3, Comments

Help!!!

br/Tan

Relevant Pages