I have an example of my data set in the two tables attached below. The data set is a table of drills where the ID field lists unique drills performed. The ProgramTable lists all the locations and their drill requirements.
I'm trying to create a report or query that would, according to today's date (Say, May 16th), list each program and the drills they are supposed to and eligible to complete. So this would result in something like the report featured in the image for my example data set.
According to my data set, Program 123 has not completed a 2nd shift drill this quarter yet, 288 has already completed a drill for the first half of the year, 082 has not, and 324 has not done a drill this month.
The challenge is creating the field/calculation "Current Requirements" in the image which tells this to the user. I'm not sure where to begin to achieve this. The farthest I've gotten is a report which lists the programs and the count of the drills they've completed this year.
Which approach should I take? I'm pretty inexperienced in Access. I can program something like this in Tableau and python, but I'm not sure how to do it here.
Thanks.
I'm trying to create a report or query that would, according to today's date (Say, May 16th), list each program and the drills they are supposed to and eligible to complete. So this would result in something like the report featured in the image for my example data set.
According to my data set, Program 123 has not completed a 2nd shift drill this quarter yet, 288 has already completed a drill for the first half of the year, 082 has not, and 324 has not done a drill this month.
The challenge is creating the field/calculation "Current Requirements" in the image which tells this to the user. I'm not sure where to begin to achieve this. The farthest I've gotten is a report which lists the programs and the count of the drills they've completed this year.
Which approach should I take? I'm pretty inexperienced in Access. I can program something like this in Tableau and python, but I'm not sure how to do it here.
Thanks.