Hello all,
I am trying to query some data from a table which have a column for the date. Noting that I have at least 200 users registered per day , I would like to query my data grouped BY WEEK and not BY DAY.
How can this be done?
Hello all,
I am trying to query some data from a table which have a column for the date. Noting that I have at least 200 users registered per day , I would like to query my data grouped BY WEEK and not BY DAY.
How can this be done?
Create field in query with expression for year and week number: Format([dateField],"yyyyww")
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Perfect it worked