I have a database that, among other thing, shows which Business Line a client is in. A client can only have one Business Line.
The business lines are:
Each record has a field called "Hours" and indicates how long our staff has spent on that client.
For my report, I would like to enter in a custom date range and show how many hours we've worked over that time frame. I have this part working. What I also want is the ability to click on one or multiple check boxes that correspond to the Business Lines and the report would show how many hours we've spent on those particular business lines.
For example, a user can check the "Marketing" box and enter a range of dates and the report would show a total of how many hours were spent on clients in the Marketing Business line over that time period.
Another example would be a user can check off the "Marketing" and the "Accounting" boxes and see the total of how many hours were spent on clients in both the Marketing and the Accounting Business lines over that time period.
I'm using FMP 15. Any help is appreciated!