pcsoft.us.windevCopyright 2026, PC SOFT22 Jan 2016 09:46:00 Z21 Jan 2016 19:46:00 ZI'd like to make a little routine that would produce something like this: 222221022022122 It's a little visual to tell me how consistent my students are training each week. The part I can figure out is how to cycle through the database. The data base just has records each day a student attends (this can be broken down by program as it has a filed for ProgramID) So I need a routine that does this... Cycle through the records by week and then determine how many classes they took that week. Then it's a simple matter of printing them out. So something like this: For Each "Week" Total attendance for this week Add it to the string as a number END Anyone have any ideas?30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/55976-how-count-attendance-weekly/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/55976-how-count-attendance-weekly-55989/read.awp22 Jan 2016 09:46:00 ZJoel, I'm using an extra "dates" table for these kind of tasks. It's used to simplify the records you read. In the end you st…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/55976-how-count-attendance-weekly-55989/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/55976-how-count-attendance-weekly-55989/read.awpHow to count attendance weeklyguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/55976-how-count-attendance-weekly-55988/read.awp22 Jan 2016 09:34:00 ZHi You can save a week number with a date. After that you can just do a for each loop. Or you can just run a querie that …https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/55976-how-count-attendance-weekly-55988/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/55976-how-count-attendance-weekly-55988/read.awpHow to count attendance weeklyguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/55976-how-count-attendance-weekly-55982/read.awp22 Jan 2016 01:00:00 ZHi Joel first, you need to loop on all the records of one student, and not on the weeks then for each record, you do a datet…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/55976-how-count-attendance-weekly-55982/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/55976-how-count-attendance-weekly-55982/read.awpHow to count attendance weekly