Query date by week

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am using Access 2000 and I have a database containing a number of dates in the form of mm/dd/yy. How can I run a query that would separate these dates by the week? I also want to run queries that will separate them by month and by year.
 
Hi,


Make a Total (Group By) query. In a free column, type

Date[Part("ww", YourDateTImeFieldnameHere)

and in the Total line, keep the proposed GroupBy. The SQL statement would be
something like

SELECT ... GROUP BY DatePart("ww", YourDateTimeFieldNameHere)


Sure, you can COUNT or SUM other fields, and the aggregation will be then
"by week". If you have to span year, add the appropriate group:



SELECT ... GROUP BY Year(YourDateTimeFieldNameHere), DatePart("ww",
YourDateTimeFieldNameHere)



Hoping it may help,
Vanderghast, Access MVP

HMS2003 said:
I am using Access 2000 and I have a database containing a number of dates
Click to expand...
in the form of mm/dd/yy. How can I run a query that would separate these
dates by the week? I also want to run queries that will separate them by
month and by year.
 
Back
Top