I am trying to get a running total of documents we process during the week, displayed in an unbound text box with a dcount as the value.
I have managed to get the daily count using:
=DCount("*","[tblDocumentLog]","Int([DateCreated])= #" & Date() & "#")
But I am struggling with the correct syntax to count all documents that have been created since the last Sunday.
I am using Australian dates (so same as UK) and the database is never used on a Sunday, so the count on Sunday does not have to be correct (ie doen't matter if it is a single day count or 7 days count).
Bonus round: total since the first of the month.
Thanks!
I have managed to get the daily count using:
=DCount("*","[tblDocumentLog]","Int([DateCreated])= #" & Date() & "#")
But I am struggling with the correct syntax to count all documents that have been created since the last Sunday.
I am using Australian dates (so same as UK) and the database is never used on a Sunday, so the count on Sunday does not have to be correct (ie doen't matter if it is a single day count or 7 days count).
Bonus round: total since the first of the month.
Thanks!