I have a database that tracks employee actions and awards them points for each action and each employee is on a team.
The database will report employees, teams, team members, employee points and team points. This all works.
Here is what I cant figure out:
We have quarterly points and of coures year ending points.
Quarter 1 = 12/1/ of any year to 2/28/ of any year
Quarter 2 = 3/1/ of any year to 5/31/ of any year
Quarter 3 = 6/1/ of any year to 8/1/ of any year
Quarter 4 = 9/1/ of any year to 11/30/ of any year
So I want a report to show the points for each quarter when pulled, Then thourght out the year show the points for all quarters thus far.
One problem is if I hard code the quarter dates it will only be good for that year and someone will have to modify the querries each year.
Second problem if I dont hard code them then the user will have to enter quarter dates everytime.
Third problem I am a novice at this
Attachment 32998