Query grouped and summed by week

[BeffyMar]

I want to create a query that sums all the fields by week so that I can chart the values.&nbsp;&nbsp;I cant seem to accomplish this task and my time-series graph never gives me what I want.&nbsp;&nbsp;Any suggestions??<br><br>THanks in advance<br>Mary Beth

 

[samara]

in your query design view, do the following...<br><br>Fields:&nbsp;&nbsp;Week&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;field1&nbsp;&nbsp;&nbsp;Field2&nbsp;&nbsp;&nbsp;and etc...<br>Total:&nbsp;&nbsp;&nbsp;groupby&nbsp;&nbsp;&nbsp;&nbsp;Sum&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Sum<br><br>to show the total row, right click at any field in grid and chosse Total<br><br>Hope this would help YOU... <p>Mohamed Aly<br><a href=mailto:samara_79@hotmail.com>samara_79@hotmail.com</a><br><a href= > </a><br>