RyanShook
5 years agoQrew Trainee
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 the school name from the parent schools table.
I want to create a report on the child table which tells me, for that day, which schools have not reported attendance. Thankfully I only have 136 schools. Somehow the child table needs to make a comparison, for that day, against the parent table for what schools are missing.
I am relatively new Quickbase user and I have exhausted my current skill set trying to come up with a way. Any strategies would be greatly appreciated.
------------------------------
Ryan Shook
------------------------------
I have a parent schools table.
I have a child table used for total enrollment per day which gets the school name from the parent schools table.
I want to create a report on the child table which tells me, for that day, which schools have not reported attendance. Thankfully I only have 136 schools. Somehow the child table needs to make a comparison, for that day, against the parent table for what schools are missing.
I am relatively new Quickbase user and I have exhausted my current skill set trying to come up with a way. Any strategies would be greatly appreciated.
------------------------------
Ryan Shook
------------------------------