I have made a vehicle database to keep track of the miles on the vehicle by day and by week. I want the total miles by week. How would i do that including the date.

---

Reply from Richard Rost:

Unfortunately, Access doesn't have a WEEK function like Excel does, but you can easily make your own as a CALCULATED QUERY FIELD:

Week: Format(MyDateField,"ww")

Now you can use that Week value in your AGGREGATE query. (This is covered, by the way, in Lesson 6 of this course... so keep watching).