Recent content by rmcafee

I thought I would post that I found a way to accomplish my goals for this database. The first step was to get a “running count” of the each student’s tardies (late to class), in the order in which they occurred.(Per Pat's suggestion) In my query of all tardies that have occurred to the...

Thanks, but I need something that doesn't prompt the user every time. My plan is to use the query or queries to set up a report that the clerks can access everyday and I want to avoid any pop ups. The report will show the students that reached each threshold on a specific day (probably the...

Yes, please post how to do the running sum. I've been looking at it and I'm having trouble with it because the field that records the tardy (Period Absence) is a text field. You can use the attached sample database. It has the same fields that I will be using.

Thanks. I've had some health issues and some other things going on and I've just now been able to revisit this. I see the SQL for the query, but where exactly do I add the dates? The start date would be 8/5/2019 and end date would be 12/20/2019. Not sure where or how to plug these in. Looks...

Yes, this sounds very promising. The last part of your response looks ideal. You're correct, I don't think I have the expertise to do all this, but I'm a pretty quick learner. Much of what I've learned has been looking at other databases and learning from them....and of course, looking for...

Honestly, the policy isn't the problem. I posted the policy in another response, you can check it out there. I haven't see a lot of criticism, mainly people putting their thoughts out there on the way they think this can be solved. There have been so many responses, I haven't even been able to...

Tardiness To Class Policy All students are expected to be in class on time as listed on the bell schedules. There is adequate time between classes and before school for students to arrive on time. Students should be in the classroom or gym before the tardy bell begins to ring. Tardies to class...

I thought the simple solution was adding the "between" criteria, but that's not the case. It simply was a coincidence that the data came out like it was working. Back to the drawing board.

Yes, data would be complete for a full day. We never run it during the school day, but can run it after school. The data is completely refreshed each day and includes all tardies for students from day one of the semester. Yes, in my real database the file is linked. We can't link directly to...

1. You only count complete days. No, each tardy stands on its own. Each tardy is a counted as a separate entry from the SIS. A student can receive several tardies on any given day. See my database example and you will see how tardies are pulled from the SIS (Student Information System) 2. You...

You're post makes perfect sense. However, from our perspective and what we do, what I'm doing right now makes sense too. It's not arbitrary, it's when the tardy reaches a specified threshold on a specific day. We have to identify quickly and call the student in. We have to catch these (threshold...

See my post below this one, it may help to clarify things. One note though, student's discipline is not "reset" after they reach 7, they continue to accumulate and can reach additional thresholds and additional disciplinary actions. So I have to know WHEN they reach each threshold, that's why...

You really need a date range. Just looking at "today" only works if you are somehow eliminating all data prior to some starting period. Yes, when I pull the data from our student information system (SIS), it automatically pulls tardies from the first day of school. So it sort of has a built in...

Yes, you're right, they keep accumulating towards the next threshold. You're seeing the exceptions that make all this difficult. Now that I have this query it will identify the student you described because it checks today's date with the thresholds their hitting. You're saying they get both the...

I think that will actually work well enough for what I need. I would like to have a column that somehow shows Tardy 7 and Tardy 8, but this will work. It will catch those students reached and passed the 7th Tardy threshold on today's date. Thanks - so simple. Created another column and added...