Search results

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...

I think you're looking at and using the wrong field in the queries to get totals/sums. The original table has each single tardy recorded, the date, and the class period [bell period] it occurred. The tardy is in the [Period Absence] field. "TDY" is the code for the tardy, on that day, and...

Here is a database with some real dates that will work for today. I have one query that will show me who reached 7 tardies (late to class) today included too. Looking for a way to find who had their 7th AND 8th tardies on today's date.

Here is a table with dummy data.

Will check it out, thanks. Going to create some dummy data for people to look at first. Will be tonight or tomorrow. USA EST

Just to clarify in the simplest terms... 1. A Tardy is late to class. 2. School records each time a student is tardy (late to class) 3. My school has 7 pds in a day. 4. A student can be late to any period, every day. 5. School issues a discipline response (like a detention) at specific tardy...