Logic Required to Calculate Data on Weekly Basis 1

[Mike555]

I have a table containing a field named "DateAdded" which contains the date that a record was added to the table. I need to create a report which summarizes data in this table by week. Is it possible to somehow setup logic which can identify dates within a week, and then build a sorting process allowing me to calculate weekly totals?

Thanks.

--
Mike

Why make it simple and efficient when it can be complex and wonderful?

 

[dhookom]

You can group by the expression:
WeekAdded: Format([DateAdded],"yyyy") & Format(DatePart("ww",[DateAdded]),"00")


Duane
MS Access MVP
Find out how to get great answers faq219-2884.