how to get weekly data from days

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have four columns as follow:
Day Product Planned,qty Actual,qty
5/1/2005 NNN 150 130
5/1/2005 SSS 1000 990
.......

It's not a problem to show the sum of planned and actual (with or without
product) for any specific period. But, how could I show sum of planned qty
and sum of actual qty by weekly for the period of year or two. I don't need
to show products.
So, it should be
Week Planned,qty Actual,qty
.....

Thanks
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Crosstab query help please 1
combining queries into 1 8
how to repeat a row from 1 until N 1
Change value of field to 0 if specific condition exists on other f 6
how do you have 2 columns totaled in a cross tab query 4
Column Heading for a CrossTab query being the next 12 weeks 4
Summing two fields from one table and dividing them in a pivot tab 6
Monthly quantities to Weekly 1

Back
Top