In this project there is one database. I have set up 2 forms.
Someone needs to set up the query that does all of the calculations and matches them to the text boxes in the form. There may be some limited amount of work needed on the forms. This produces Sales Stats for an Office for period of time for all active agents and it also produces Sales Stats for an Office for period of time for an active agent. I prefer no code if possible.
I made the changes that you requested and have a working copy of the database that you uploaded. I have not used any code to implement the changes that you requested.
Sincerely