I need help with counting date

  • Thread starter Thread starter Al
  • Start date Start date
A

Al

I have 2 fields in a query (RA = research associate, and
prognotedate = progress notes date).I need to count the
number of records entered per week per RA starting (Date()-
1)backward. I also need the minimum date in every week.
can someone help?
thanks
Al
 
ONE possible solution would be a query like the following.


SELECT RA,
Format(ProgNoteDate,"YYYY-WW") as YearWeek,
Count(ProgNoteDate) as NoteCount,
Min(ProgNoteDate) as MinDate
FROM YourTable
WHERE ProgNoteDate < Date() -1
GROUP BY RA, Format(ProgNoteDate,"YYYY-WW") as YearWeek
 
Back
Top