Weekly Total

[coffeyja]

I have a data base that i am creating and I'm having problems consolidating weekend information. On a daily basis I enter data and that turn into a query at some point. For my weekend information want to summarize the daily data by a weekend date. I can get the data summarized however I cannot find a way to get the weekend date as part of my last query. Any suggestions?

[June7]

You want to summarize data by weekly?

DatePart("ww",Date()) will return number of the week that date falls in within a calendar year. Which means 12/31/2012 and 1/1/2013 will not be captured in the same week number even though they are actually in the same week. Do you want data capture to cross years?

If your data is multi-year, will have to extract the year from each date and include both the week and year in any filter/group/sort criteria.

What day is end of week for you - Saturday?

[coffeyja]

My weeks end on Saturday and I will need to have a weekend date that caputes across years.

[June7]

This will calculate the last day of the week for given date:

[datefield] + (Weekday([datefield]) * (-1) + 1) + 6

Use this expression to create a field in query and group records.