I just began using Microsoft Access and am creating a database to handle Weekly Activity reporting. For example, during the week of 3/16/15 through 3/20/15, I sent 29 emails, received 12 emails, attended 6 meetings, etc.
I am trying to figure out a way to handle the "Week Ending" date. For each weekly activity report, there must be a "Week Ending" date - which must be the Friday of the current week. Any suggestions on how to go about doing so?
I have a Users table that holds the username, network id, and password. I also have a Weekly table that holds each element I want shown on my Weekly Activity report (e.g. emails sent, emails received, meetings attended, etc.).