List:General Discussion« Previous MessageNext Message »
From:Imran Date:January 15 2008 10:23pm
Subject:Help with this query
View as plain text  
Hi:

 

I have a table that I need help to summarize the data. I need to be able to
create one row of data for custno + prodno + period + weekno combination
summarized by Invtot. 

 

Any help will be greatly appreciated.

 

Best regards

 

 

 

I am attaching the relevant info below:

 

Sales Table

 

CustNo

ProdNo

Period

WeekNo

InvTot

InvDate

 

Data

---------

CustNo ProdNo Period   WeekNo            InvTot    InvDate

0001     0500     2007-01 01         111.11  2007/01/01

0001     0500     2007-01 01         112.11  2007/01/01

0001     0500     2007-01 01         113.11  2007/01/02

0001     0500     2007-02 01         114.11  2007/02/02

0001     0500     2007-02 01         115.11  2007/02/02

0001     0500     2007-02 01         116.11  2007/02/02

0001     0500     2007-04 21         117.11  2007/04/08

0001     0500     2007-04 21         118.11  2007/04/08

0001     0500     2007-04 21         119.11  2007/04/08

0001     0501     2007-05 25         111.11  2007/05/01

0001     0501     2007-05 25         112.11  2007/05/01

0001     0501     2007-05 25         113.11  2007/05/02

0001     0501     2007-05 25         114.11  2007/05/02

0001     0501     2007-06 30         115.11  2007/06/02

0001     0505     2007-06 30         116.11  2007/06/02

0001     0505     2007-06 30         117.11  2007/06/08

0001     0506     2007-06 30         118.11  2007/06/08

0001     0507     2007-06 30         119.11  2007/06/08


Thread
Help with this queryImran15 Jan
  • Re: Help with this queryMoon's Father16 Jan