Filter by week

I

Info

Like this:
I have a field in a table is type date, and i want to make calculation by
week in form, so is possible to filter all the date by week and make
calculation in them?
 
S

scubadiver

You can do it in a query. Put the following in a field

WeekNo: format([fieldname],"ww")

This will classify a date according to what week of the year it is. Then you
can base your calculations on it.
 
Top