Query question

[proben930]

I have a table with that has a date field and several fields containing numbers. I would like to a query that will sum the numbers by week. ie, have a beginning week date in column 1 and a value (sum) in column 2. I created another table that has beginning, ending dates of the weeks but I can't seem to put the two together. Any ideas? TIA!

 

[KenHigg]

Could you just do a totals query using the date range as a parameter?

kh

 

[Rich]

you don't need to store the week ending date, just use the Week function in a totals query and group by it

 

[proben930]

Great, I got it to work. Thanks! Any ideas how to make it output say, the first day of the week, instead of the week #?

 

[Rich]

Pat Hartman has posted a sample DB here on working with dates, I suspect there's an example in it