Looking for a report strategy
I am looking for a way to create a report for schools that have not reported attendance that day. I have a parent schools table. I have a child table used for total enrollment per day which gets ...
Forum Discussion
np
On the relationship make a summary field of the # of Children where the Reporting Date is equal to Today. Set the checkbox on that field to treat blank as zero. Call it [# of of Attendance Reports for Today]
Then make a Report on the Parent Schools table where [# of of Attendance Reports for Today] = 0.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
On the relationship make a summary field of the # of Children where the Reporting Date is equal to Today. Set the checkbox on that field to treat blank as zero. Call it [# of of Attendance Reports for Today]
Then make a Report on the Parent Schools table where [# of of Attendance Reports for Today] = 0.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
You are a lifesaver. Not only that, you just taught me a technique that I carry over to many other tables. Thank you so much!
|
|
------Original Message------
np
On the relationship make a summary field of the # of Children where the Reporting Date is equal to Today. Set the checkbox on that field to treat blank as zero. Call it [# of of Attendance Reports for Today]
Then make a Report on the Parent Schools table where [# of of Attendance Reports for Today] = 0.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
